{smcl}
{com}{sf}{ul off}{txt}{.-}
      name:  {res}<unnamed>
       {txt}log:  {res}R:\WSV2\TBu_AKe\Spatial_NEW\spatial_1_raw_s.smcl
  {txt}log type:  {res}smcl
 {txt}opened on:  {res}27 Mar 2023, 17:33:41
{txt}
{com}. cd // display in log file 
{res}R:\WSV2\TBu_AKe\Spatial_NEW
{txt}
{com}. 
. ** load product-level data ** 
. use "R:\WSV2\TBu_AKe\Product Ban\Stata\Bunching_Empirics\WM_V10_precollapse_binbasis.dta"
{txt}
{com}.  
. gen kwh = ae // annual energy consumption 
{txt}(689,472 missing values generated)

{com}. 
. scalar sigma = 0.59*47 // attribute slope from regulation
{txt}
{com}. scalar kappa = 0.59*51.7 // intercept from regulation 
{txt}
{com}. scalar D = 3 // increment for cell height 
{txt}
{com}. 
.         ** std. energy consumption
. gen s = kwh - `=sigma'*capacity    
{txt}(689,472 missing values generated)

{com}. replace s = s - `=kappa'  // values below zero are compliant 
{txt}(500,101 real changes made)

{com}. sum s, detail // - 253 to 341

                              {txt}s
{hline 61}
      Percentiles      Smallest
 1%    {res} -150.073       -253.263
{txt} 5%    {res} -115.343       -253.263
{txt}10%    {res}  -83.343       -253.263       {txt}Obs         {res}    500,101
{txt}25%    {res}  -58.343       -253.263       {txt}Sum of wgt. {res}    500,101

{txt}50%    {res}  -30.613                      {txt}Mean          {res}-34.81277
                        {txt}Largest       Std. dev.     {res} 43.06756
{txt}75%    {res}-4.152999        957.792
{txt}90%    {res} 7.116999        957.792       {txt}Variance      {res} 1854.815
{txt}95%    {res}   20.847        957.792       {txt}Skewness      {res} .9977435
{txt}99%    {res}   56.927        957.792       {txt}Kurtosis      {res} 27.16255
{txt}
{com}. 
.  ** basic descriptives
. sum kwh capacity, detail

                             {txt}kwh
{hline 61}
      Percentiles      Smallest
 1%    {res}      116             58
{txt} 5%    {res}      137             58
{txt}10%    {res}      148             58       {txt}Obs         {res}    500,101
{txt}25%    {res}      163             58       {txt}Sum of wgt. {res}    500,101

{txt}50%    {res}      174                      {txt}Mean          {res} 180.0771
                        {txt}Largest       Std. dev.     {res} 34.29484
{txt}75%    {res}      194           1224
{txt}90%    {res}      216           1224       {txt}Variance      {res} 1176.136
{txt}95%    {res}      238           1224       {txt}Skewness      {res} 3.843271
{txt}99%    {res}      299           1224       {txt}Kurtosis      {res} 74.38685

                          {txt}capacity
{hline 61}
      Percentiles      Smallest
 1%    {res}      3.5            1.5
{txt} 5%    {res}      4.5            1.5
{txt}10%    {res}        5            1.5       {txt}Obs         {res}  1,186,121
{txt}25%    {res}        5            1.5       {txt}Sum of wgt. {res}  1,186,121

{txt}50%    {res}        6                      {txt}Mean          {res} 6.022605
                        {txt}Largest       Std. dev.     {res} 1.263033
{txt}75%    {res}        7             16
{txt}90%    {res}        8             16       {txt}Variance      {res} 1.595253
{txt}95%    {res}        8             16       {txt}Skewness      {res} .8587801
{txt}99%    {res}       10             16       {txt}Kurtosis      {res} 4.776902
{txt}
{com}. drop if kwh > 600 // max: DAEWOO can be dropped, reduce to 600. 
{txt}(689,508 observations deleted)

{com}. sort year
{txt}
{com}. by year: summ kwh capacity, detail

{txt}{hline}
-> year = 2004

                             kwh
{hline 61}
      Percentiles      Smallest
 1%    {res}      126            126
{txt} 5%    {res}      126            126
{txt}10%    {res}      126            126       {txt}Obs         {res}        473
{txt}25%    {res}      132            126       {txt}Sum of wgt. {res}        473

{txt}50%    {res}      190                      {txt}Mean          {res}  183.907
                        {txt}Largest       Std. dev.     {res} 44.59754
{txt}75%    {res}      209            308
{txt}90%    {res}      242            308       {txt}Variance      {res}  1988.94
{txt}95%    {res}      242            308       {txt}Skewness      {res}  .489168
{txt}99%    {res}      308            308       {txt}Kurtosis      {res} 2.986277

                          {txt}capacity
{hline 61}
      Percentiles      Smallest
 1%    {res}        3              3
{txt} 5%    {res}        3              3
{txt}10%    {res}        3              3       {txt}Obs         {res}        473
{txt}25%    {res}      3.5              3       {txt}Sum of wgt. {res}        473

{txt}50%    {res}        5                      {txt}Mean          {res} 4.825581
                        {txt}Largest       Std. dev.     {res} 1.110772
{txt}75%    {res}        6            7.5
{txt}90%    {res}        6            7.5       {txt}Variance      {res} 1.233815
{txt}95%    {res}        6            7.5       {txt}Skewness      {res}-.2458917
{txt}99%    {res}      7.5            7.5       {txt}Kurtosis      {res} 2.389934

{txt}{hline}
-> year = 2005

                             kwh
{hline 61}
      Percentiles      Smallest
 1%    {res}      126            126
{txt} 5%    {res}      126            126
{txt}10%    {res}      132            126       {txt}Obs         {res}      1,000
{txt}25%    {res}      170            126       {txt}Sum of wgt. {res}      1,000

{txt}50%    {res}    173.5                      {txt}Mean          {res}   183.16
                        {txt}Largest       Std. dev.     {res} 34.75725
{txt}75%    {res}      204            308
{txt}90%    {res}      224            308       {txt}Variance      {res} 1208.066
{txt}95%    {res}      242            308       {txt}Skewness      {res} .6918117
{txt}99%    {res}      308            308       {txt}Kurtosis      {res} 4.397655

                          {txt}capacity
{hline 61}
      Percentiles      Smallest
 1%    {res}        3              3
{txt} 5%    {res}        3              3
{txt}10%    {res}      3.5              3       {txt}Obs         {res}      1,000
{txt}25%    {res}        5              3       {txt}Sum of wgt. {res}      1,000

{txt}50%    {res}        5                      {txt}Mean          {res}   5.2455
                        {txt}Largest       Std. dev.     {res} .9784872
{txt}75%    {res}        6            7.5
{txt}90%    {res}        6            7.5       {txt}Variance      {res} .9574372
{txt}95%    {res}        6            7.5       {txt}Skewness      {res}-.8876818
{txt}99%    {res}      7.5            7.5       {txt}Kurtosis      {res} 3.308829

{txt}{hline}
-> year = 2006

                             kwh
{hline 61}
      Percentiles      Smallest
 1%    {res}      126            126
{txt} 5%    {res}      132            126
{txt}10%    {res}      152            126       {txt}Obs         {res}      2,276
{txt}25%    {res}      171            126       {txt}Sum of wgt. {res}      2,276

{txt}50%    {res}      187                      {txt}Mean          {res}  187.775
                        {txt}Largest       Std. dev.     {res} 35.25188
{txt}75%    {res}      204            438
{txt}90%    {res}      224            438       {txt}Variance      {res} 1242.695
{txt}95%    {res}      238            438       {txt}Skewness      {res} 2.298313
{txt}99%    {res}      308            438       {txt}Kurtosis      {res} 15.54747

                          {txt}capacity
{hline 61}
      Percentiles      Smallest
 1%    {res}        3              3
{txt} 5%    {res}      3.5              3
{txt}10%    {res}      4.5              3       {txt}Obs         {res}      2,276
{txt}25%    {res}        5              3       {txt}Sum of wgt. {res}      2,276

{txt}50%    {res}      5.5                      {txt}Mean          {res} 5.495826
                        {txt}Largest       Std. dev.     {res} .9605883
{txt}75%    {res}        6              8
{txt}90%    {res}        6              8       {txt}Variance      {res} .9227298
{txt}95%    {res}        7              8       {txt}Skewness      {res} .0434821
{txt}99%    {res}        8              8       {txt}Kurtosis      {res}  4.33401

{txt}{hline}
-> year = 2007

                             kwh
{hline 61}
      Percentiles      Smallest
 1%    {res}      126            126
{txt} 5%    {res}      152            126
{txt}10%    {res}      167            126       {txt}Obs         {res}      4,049
{txt}25%    {res}      171            126       {txt}Sum of wgt. {res}      4,049

{txt}50%    {res}      190                      {txt}Mean          {res} 197.0393
                        {txt}Largest       Std. dev.     {res} 45.09904
{txt}75%    {res}      204            438
{txt}90%    {res}      238            438       {txt}Variance      {res} 2033.924
{txt}95%    {res}      299            438       {txt}Skewness      {res} 2.393205
{txt}99%    {res}      372            438       {txt}Kurtosis      {res} 11.04646

                          {txt}capacity
{hline 61}
      Percentiles      Smallest
 1%    {res}        3              3
{txt} 5%    {res}      4.5              3
{txt}10%    {res}        5              3       {txt}Obs         {res}      4,049
{txt}25%    {res}        5              3       {txt}Sum of wgt. {res}      4,049

{txt}50%    {res}        6                      {txt}Mean          {res} 5.792294
                        {txt}Largest       Std. dev.     {res} 1.102662
{txt}75%    {res}        6             10
{txt}90%    {res}        7             10       {txt}Variance      {res} 1.215865
{txt}95%    {res}        8             10       {txt}Skewness      {res}  .821838
{txt}99%    {res}       10             10       {txt}Kurtosis      {res} 5.161725

{txt}{hline}
-> year = 2008

                             kwh
{hline 61}
      Percentiles      Smallest
 1%    {res}      126            114
{txt} 5%    {res}      152            114
{txt}10%    {res}      167            114       {txt}Obs         {res}      6,257
{txt}25%    {res}      173            114       {txt}Sum of wgt. {res}      6,257

{txt}50%    {res}      190                      {txt}Mean          {res} 198.0182
                        {txt}Largest       Std. dev.     {res} 43.69501
{txt}75%    {res}      209            438
{txt}90%    {res}      238            438       {txt}Variance      {res} 1909.254
{txt}95%    {res}      272            438       {txt}Skewness      {res} 2.257911
{txt}99%    {res}      372            438       {txt}Kurtosis      {res} 10.37685

                          {txt}capacity
{hline 61}
      Percentiles      Smallest
 1%    {res}        3              3
{txt} 5%    {res}      4.5              3
{txt}10%    {res}        5              3       {txt}Obs         {res}      6,257
{txt}25%    {res}        5              3       {txt}Sum of wgt. {res}      6,257

{txt}50%    {res}        6                      {txt}Mean          {res} 5.908343
                        {txt}Largest       Std. dev.     {res} 1.106587
{txt}75%    {res}        6             10
{txt}90%    {res}        7             10       {txt}Variance      {res} 1.224534
{txt}95%    {res}        8             10       {txt}Skewness      {res} .7675504
{txt}99%    {res}       10             10       {txt}Kurtosis      {res} 4.953352

{txt}{hline}
-> year = 2009

                             kwh
{hline 61}
      Percentiles      Smallest
 1%    {res}      132          99.84
{txt} 5%    {res}      155          99.84
{txt}10%    {res}      167          99.84       {txt}Obs         {res}     12,340
{txt}25%    {res}      173          99.84       {txt}Sum of wgt. {res}     12,340

{txt}50%    {res}      190                      {txt}Mean          {res} 200.4195
                        {txt}Largest       Std. dev.     {res} 42.81153
{txt}75%    {res}      211            485
{txt}90%    {res}      240            485       {txt}Variance      {res} 1832.827
{txt}95%    {res}      272            485       {txt}Skewness      {res} 2.067186
{txt}99%    {res}      372            485       {txt}Kurtosis      {res}  9.62121

                          {txt}capacity
{hline 61}
      Percentiles      Smallest
 1%    {res}      3.5              3
{txt} 5%    {res}      4.5              3
{txt}10%    {res}        5              3       {txt}Obs         {res}     12,340
{txt}25%    {res}        5              3       {txt}Sum of wgt. {res}     12,340

{txt}50%    {res}        6                      {txt}Mean          {res} 6.039951
                        {txt}Largest       Std. dev.     {res} 1.100409
{txt}75%    {res}        7             10
{txt}90%    {res}        7             10       {txt}Variance      {res} 1.210901
{txt}95%    {res}        8             10       {txt}Skewness      {res} .4370468
{txt}99%    {res}        9             10       {txt}Kurtosis      {res} 4.144477

{txt}{hline}
-> year = 2010

                             kwh
{hline 61}
      Percentiles      Smallest
 1%    {res}      132          99.84
{txt} 5%    {res}      158          99.84
{txt}10%    {res}      165          99.84       {txt}Obs         {res}     21,071
{txt}25%    {res}      173          99.84       {txt}Sum of wgt. {res}     21,071

{txt}50%    {res}      190                      {txt}Mean          {res} 198.3411
                        {txt}Largest       Std. dev.     {res} 42.47831
{txt}75%    {res}      209            580
{txt}90%    {res}      238            580       {txt}Variance      {res} 1804.407
{txt}95%    {res}      272            580       {txt}Skewness      {res} 2.611005
{txt}99%    {res}      372            580       {txt}Kurtosis      {res} 14.50087

                          {txt}capacity
{hline 61}
      Percentiles      Smallest
 1%    {res}      3.5              3
{txt} 5%    {res}        5              3
{txt}10%    {res}        5              3       {txt}Obs         {res}     21,071
{txt}25%    {res}      5.5              3       {txt}Sum of wgt. {res}     21,071

{txt}50%    {res}        6                      {txt}Mean          {res} 6.205244
                        {txt}Largest       Std. dev.     {res} 1.109117
{txt}75%    {res}        7             11
{txt}90%    {res}        8             11       {txt}Variance      {res} 1.230141
{txt}95%    {res}        8             11       {txt}Skewness      {res} .2312123
{txt}99%    {res}        9             11       {txt}Kurtosis      {res}  3.71512

{txt}{hline}
-> year = 2011

                             kwh
{hline 61}
      Percentiles      Smallest
 1%    {res}      132          99.84
{txt} 5%    {res}      157          99.84
{txt}10%    {res}      160          99.84       {txt}Obs         {res}     37,766
{txt}25%    {res}      171          99.84       {txt}Sum of wgt. {res}     37,766

{txt}50%    {res}      190                      {txt}Mean          {res} 194.1969
                        {txt}Largest       Std. dev.     {res} 35.97598
{txt}75%    {res}      204            580
{txt}90%    {res}      238            580       {txt}Variance      {res} 1294.271
{txt}95%    {res}      252            580       {txt}Skewness      {res}  2.58353
{txt}99%    {res}      346            580       {txt}Kurtosis      {res} 16.14307

                          {txt}capacity
{hline 61}
      Percentiles      Smallest
 1%    {res}      3.5              3
{txt} 5%    {res}        5              3
{txt}10%    {res}        5              3       {txt}Obs         {res}     37,766
{txt}25%    {res}        6              3       {txt}Sum of wgt. {res}     37,766

{txt}50%    {res}        6                      {txt}Mean          {res} 6.420746
                        {txt}Largest       Std. dev.     {res} 1.142844
{txt}75%    {res}        7             12
{txt}90%    {res}        8             12       {txt}Variance      {res} 1.306093
{txt}95%    {res}        8             12       {txt}Skewness      {res} .5298971
{txt}99%    {res}       10             12       {txt}Kurtosis      {res} 4.620945

{txt}{hline}
-> year = 2012

                             kwh
{hline 61}
      Percentiles      Smallest
 1%    {res}      132             99
{txt} 5%    {res}      150             99
{txt}10%    {res}      158             99       {txt}Obs         {res}     60,390
{txt}25%    {res}      170             99       {txt}Sum of wgt. {res}     60,390

{txt}50%    {res}      187                      {txt}Mean          {res} 188.6502
                        {txt}Largest       Std. dev.     {res} 32.70832
{txt}75%    {res}      197            580
{txt}90%    {res}      224            580       {txt}Variance      {res} 1069.834
{txt}95%    {res}      240            580       {txt}Skewness      {res}  2.56242
{txt}99%    {res}      302            580       {txt}Kurtosis      {res}  17.9688

                          {txt}capacity
{hline 61}
      Percentiles      Smallest
 1%    {res}        4              3
{txt} 5%    {res}        5              3
{txt}10%    {res}        5              3       {txt}Obs         {res}     60,390
{txt}25%    {res}        6              3       {txt}Sum of wgt. {res}     60,390

{txt}50%    {res}        6                      {txt}Mean          {res} 6.513337
                        {txt}Largest       Std. dev.     {res} 1.156403
{txt}75%    {res}        7             12
{txt}90%    {res}        8             12       {txt}Variance      {res} 1.337269
{txt}95%    {res}        8             12       {txt}Skewness      {res} .5788142
{txt}99%    {res}       10             12       {txt}Kurtosis      {res} 4.630118

{txt}{hline}
-> year = 2013

                             kwh
{hline 61}
      Percentiles      Smallest
 1%    {res}      127             99
{txt} 5%    {res}      145             99
{txt}10%    {res}      152             99       {txt}Obs         {res}     78,090
{txt}25%    {res}      166             99       {txt}Sum of wgt. {res}     78,090

{txt}50%    {res}      177                      {txt}Mean          {res}  182.663
                        {txt}Largest       Std. dev.     {res} 30.86441
{txt}75%    {res}      196            580
{txt}90%    {res}      218            580       {txt}Variance      {res} 952.6117
{txt}95%    {res}      238            580       {txt}Skewness      {res} 2.368519
{txt}99%    {res}      287            580       {txt}Kurtosis      {res} 17.81683

                          {txt}capacity
{hline 61}
      Percentiles      Smallest
 1%    {res}        4              3
{txt} 5%    {res}        5              3
{txt}10%    {res}        5              3       {txt}Obs         {res}     78,090
{txt}25%    {res}        6              3       {txt}Sum of wgt. {res}     78,090

{txt}50%    {res}      6.5                      {txt}Mean          {res} 6.570744
                        {txt}Largest       Std. dev.     {res} 1.198212
{txt}75%    {res}        7             15
{txt}90%    {res}        8             15       {txt}Variance      {res} 1.435711
{txt}95%    {res}        8             15       {txt}Skewness      {res} .7090729
{txt}99%    {res}       10             15       {txt}Kurtosis      {res} 5.399325

{txt}{hline}
-> year = 2014

                             kwh
{hline 61}
      Percentiles      Smallest
 1%    {res}      122             89
{txt} 5%    {res}      137             89
{txt}10%    {res}      148             89       {txt}Obs         {res}     86,773
{txt}25%    {res}      161             89       {txt}Sum of wgt. {res}     86,773

{txt}50%    {res}      173                      {txt}Mean          {res} 177.5918
                        {txt}Largest       Std. dev.     {res} 29.29345
{txt}75%    {res}      194            504
{txt}90%    {res}      206            504       {txt}Variance      {res} 858.1061
{txt}95%    {res}      224            504       {txt}Skewness      {res} 1.798084
{txt}99%    {res}      271            580       {txt}Kurtosis      {res} 13.38695

                          {txt}capacity
{hline 61}
      Percentiles      Smallest
 1%    {res}        4              3
{txt} 5%    {res}        5              3
{txt}10%    {res}        5              3       {txt}Obs         {res}     86,773
{txt}25%    {res}        6              3       {txt}Sum of wgt. {res}     86,773

{txt}50%    {res}        7                      {txt}Mean          {res} 6.678157
                        {txt}Largest       Std. dev.     {res}  1.21647
{txt}75%    {res}        7             15
{txt}90%    {res}        8             15       {txt}Variance      {res}   1.4798
{txt}95%    {res}        9             15       {txt}Skewness      {res} .6901523
{txt}99%    {res}       10             15       {txt}Kurtosis      {res} 5.380691

{txt}{hline}
-> year = 2015

                             kwh
{hline 61}
      Percentiles      Smallest
 1%    {res}      105             58
{txt} 5%    {res}      135             58
{txt}10%    {res}      140             58       {txt}Obs         {res}     88,466
{txt}25%    {res}      153             58       {txt}Sum of wgt. {res}     88,466

{txt}50%    {res}      171                      {txt}Mean          {res} 172.5232
                        {txt}Largest       Std. dev.     {res} 28.17306
{txt}75%    {res}      191            416
{txt}90%    {res}      197            434       {txt}Variance      {res} 793.7214
{txt}95%    {res}      220            438       {txt}Skewness      {res} 1.230043
{txt}99%    {res}      256            504       {txt}Kurtosis      {res} 10.40038

                          {txt}capacity
{hline 61}
      Percentiles      Smallest
 1%    {res}        4              3
{txt} 5%    {res}        5              3
{txt}10%    {res}      5.5              3       {txt}Obs         {res}     88,466
{txt}25%    {res}        6              3       {txt}Sum of wgt. {res}     88,466

{txt}50%    {res}        7                      {txt}Mean          {res} 6.834501
                        {txt}Largest       Std. dev.     {res} 1.237553
{txt}75%    {res}        8             15
{txt}90%    {res}        8             15       {txt}Variance      {res} 1.531537
{txt}95%    {res}        9             15       {txt}Skewness      {res} .6387173
{txt}99%    {res}       10             15       {txt}Kurtosis      {res} 5.228658

{txt}{hline}
-> year = 2016

                             kwh
{hline 61}
      Percentiles      Smallest
 1%    {res}      104             58
{txt} 5%    {res}      122             58
{txt}10%    {res}      137             58       {txt}Obs         {res}     89,176
{txt}25%    {res}      152             58       {txt}Sum of wgt. {res}     89,176

{txt}50%    {res}      168                      {txt}Mean          {res} 167.9801
                        {txt}Largest       Std. dev.     {res} 28.45437
{txt}75%    {res}      185            386
{txt}90%    {res}      196            386       {txt}Variance      {res} 809.6511
{txt}95%    {res}      216            386       {txt}Skewness      {res} .9884465
{txt}99%    {res}      251            416       {txt}Kurtosis      {res} 8.982155

                          {txt}capacity
{hline 61}
      Percentiles      Smallest
 1%    {res}        4              3
{txt} 5%    {res}        5              3
{txt}10%    {res}        6              3       {txt}Obs         {res}     89,176
{txt}25%    {res}        6              3       {txt}Sum of wgt. {res}     89,176

{txt}50%    {res}        7                      {txt}Mean          {res} 6.981357
                        {txt}Largest       Std. dev.     {res} 1.275999
{txt}75%    {res}        8             15
{txt}90%    {res}        8             15       {txt}Variance      {res} 1.628172
{txt}95%    {res}        9             15       {txt}Skewness      {res} .6418291
{txt}99%    {res}       11             15       {txt}Kurtosis      {res} 5.161957

{txt}{hline}
-> year = 2017

                             kwh
{hline 61}
      Percentiles      Smallest
 1%    {res}       98             58
{txt} 5%    {res}      122             58
{txt}10%    {res}      136             58       {txt}Obs         {res}     11,938
{txt}25%    {res}      151             58       {txt}Sum of wgt. {res}     11,938

{txt}50%    {res}      167                      {txt}Mean          {res} 166.0863
                        {txt}Largest       Std. dev.     {res} 28.20101
{txt}75%    {res}      177            386
{txt}90%    {res}      196            386       {txt}Variance      {res} 795.2971
{txt}95%    {res}      211            386       {txt}Skewness      {res} .9865577
{txt}99%    {res}      244            386       {txt}Kurtosis      {res} 9.282613

                          {txt}capacity
{hline 61}
      Percentiles      Smallest
 1%    {res}        4              3
{txt} 5%    {res}        5              3
{txt}10%    {res}        6              3       {txt}Obs         {res}     11,938
{txt}25%    {res}        6              3       {txt}Sum of wgt. {res}     11,938

{txt}50%    {res}        7                      {txt}Mean          {res} 7.010931
                        {txt}Largest       Std. dev.     {res} 1.277453
{txt}75%    {res}        8             15
{txt}90%    {res}        9             15       {txt}Variance      {res} 1.631886
{txt}95%    {res}        9             15       {txt}Skewness      {res} .6477091
{txt}99%    {res}       11             15       {txt}Kurtosis      {res} 5.169922

{txt}
{com}. tab capacity // size in kg 

   {txt}capacity {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          3 {c |}{res}      1,831        0.37        0.37
{txt}        3.5 {c |}{res}      3,043        0.61        0.97
{txt}          4 {c |}{res}      3,551        0.71        1.68
{txt}        4.5 {c |}{res}      4,021        0.80        2.49
{txt}          5 {c |}{res}     53,672       10.73       13.22
{txt}        5.5 {c |}{res}     21,180        4.24       17.46
{txt}          6 {c |}{res}    149,354       29.87       47.32
{txt}        6.2 {c |}{res}         48        0.01       47.33
{txt}        6.5 {c |}{res}      4,487        0.90       48.23
{txt}          7 {c |}{res}    148,026       29.60       77.83
{txt}        7.5 {c |}{res}        156        0.03       77.86
{txt}          8 {c |}{res}     83,359       16.67       94.53
{txt}          9 {c |}{res}     18,009        3.60       98.13
{txt}         10 {c |}{res}      5,285        1.06       99.19
{txt}         11 {c |}{res}      2,093        0.42       99.61
{txt}         12 {c |}{res}      1,665        0.33       99.94
{txt}         13 {c |}{res}        126        0.03       99.97
{txt}         14 {c |}{res}         12        0.00       99.97
{txt}         15 {c |}{res}        147        0.03      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    500,065      100.00
{txt}
{com}. 
. summ eei, detail 

                             {txt}eei
{hline 61}
      Percentiles      Smallest
 1%    {res}  27.3181       13.56091
{txt} 5%    {res}  32.0318       13.56091
{txt}10%    {res} 38.91125       13.56091       {txt}Obs         {res}    500,065
{txt}25%    {res} 44.65089       13.56091       {txt}Sum of wgt. {res}    500,065

{txt}50%    {res} 50.64429                      {txt}Mean          {res}  50.3538
                        {txt}Largest       Std. dev.     {res} 10.42067
{txt}75%    {res} 57.55145       143.4933
{txt}90%    {res} 61.13275       143.4933       {txt}Variance      {res} 108.5903
{txt}95%    {res} 66.27136       143.4933       {txt}Skewness      {res} 1.076723
{txt}99%    {res} 76.03767       143.4933       {txt}Kurtosis      {res} 9.543992
{txt}
{com}. tab eei_bin // increments of 0.5 

    {txt}eei_bin {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
       13.5 {c |}{res}        164        0.03        0.03
{txt}         16 {c |}{res}          1        0.00        0.03
{txt}       17.5 {c |}{res}         63        0.01        0.05
{txt}         18 {c |}{res}        177        0.04        0.08
{txt}         19 {c |}{res}         13        0.00        0.08
{txt}       20.5 {c |}{res}        518        0.10        0.19
{txt}         22 {c |}{res}      1,033        0.21        0.39
{txt}       22.5 {c |}{res}      1,477        0.30        0.69
{txt}         25 {c |}{res}         99        0.02        0.71
{txt}         26 {c |}{res}         50        0.01        0.72
{txt}       26.5 {c |}{res}        315        0.06        0.78
{txt}         27 {c |}{res}      3,329        0.67        1.45
{txt}       27.5 {c |}{res}        329        0.07        1.51
{txt}         28 {c |}{res}         73        0.01        1.53
{txt}       28.5 {c |}{res}         84        0.02        1.54
{txt}         29 {c |}{res}         36        0.01        1.55
{txt}       29.5 {c |}{res}      1,015        0.20        1.75
{txt}       30.5 {c |}{res}         26        0.01        1.76
{txt}       31.5 {c |}{res}      3,596        0.72        2.48
{txt}         32 {c |}{res}     16,062        3.21        5.69
{txt}       32.5 {c |}{res}        616        0.12        5.81
{txt}         33 {c |}{res}        416        0.08        5.90
{txt}       33.5 {c |}{res}        108        0.02        5.92
{txt}       34.5 {c |}{res}        132        0.03        5.95
{txt}         35 {c |}{res}        561        0.11        6.06
{txt}       35.5 {c |}{res}        733        0.15        6.20
{txt}         36 {c |}{res}      5,864        1.17        7.38
{txt}       36.5 {c |}{res}      5,963        1.19        8.57
{txt}         37 {c |}{res}        432        0.09        8.66
{txt}       37.5 {c |}{res}      1,415        0.28        8.94
{txt}         38 {c |}{res}      2,837        0.57        9.51
{txt}       38.5 {c |}{res}      2,594        0.52       10.02
{txt}         39 {c |}{res}      1,560        0.31       10.34
{txt}       39.5 {c |}{res}      4,116        0.82       11.16
{txt}         40 {c |}{res}        916        0.18       11.34
{txt}       40.5 {c |}{res}      2,747        0.55       11.89
{txt}         41 {c |}{res}      9,070        1.81       13.71
{txt}       41.5 {c |}{res}      1,729        0.35       14.05
{txt}         42 {c |}{res}      8,763        1.75       15.80
{txt}       42.5 {c |}{res}      5,027        1.01       16.81
{txt}         43 {c |}{res}     10,427        2.09       18.89
{txt}       43.5 {c |}{res}      7,643        1.53       20.42
{txt}         44 {c |}{res}     21,741        4.35       24.77
{txt}       44.5 {c |}{res}     24,172        4.83       29.60
{txt}         45 {c |}{res}     18,579        3.72       33.32
{txt}       45.5 {c |}{res}     51,072       10.21       43.53
{txt}         46 {c |}{res}      1,494        0.30       43.83
{txt}       46.5 {c |}{res}      2,257        0.45       44.28
{txt}         47 {c |}{res}      1,849        0.37       44.65
{txt}       47.5 {c |}{res}      1,922        0.38       45.04
{txt}         48 {c |}{res}      1,873        0.37       45.41
{txt}       48.5 {c |}{res}      2,359        0.47       45.88
{txt}         49 {c |}{res}     10,827        2.17       48.05
{txt}       49.5 {c |}{res}      2,241        0.45       48.50
{txt}         50 {c |}{res}      7,345        1.47       49.97
{txt}       50.5 {c |}{res}     24,178        4.83       54.80
{txt}         51 {c |}{res}      8,375        1.67       56.48
{txt}       51.5 {c |}{res}     32,455        6.49       62.97
{txt}         52 {c |}{res}      6,680        1.34       64.30
{txt}       52.5 {c |}{res}        655        0.13       64.43
{txt}         53 {c |}{res}      1,755        0.35       64.78
{txt}       53.5 {c |}{res}      3,023        0.60       65.39
{txt}         54 {c |}{res}      1,205        0.24       65.63
{txt}       54.5 {c |}{res}      3,121        0.62       66.25
{txt}         55 {c |}{res}     11,874        2.37       68.63
{txt}       55.5 {c |}{res}      3,883        0.78       69.40
{txt}         56 {c |}{res}      5,468        1.09       70.50
{txt}       56.5 {c |}{res}      9,162        1.83       72.33
{txt}         57 {c |}{res}      5,348        1.07       73.40
{txt}       57.5 {c |}{res}     14,117        2.82       76.22
{txt}         58 {c |}{res}     20,314        4.06       80.28
{txt}       58.5 {c |}{res}     29,394        5.88       86.16
{txt}         59 {c |}{res}     10,158        2.03       88.19
{txt}       59.5 {c |}{res}      3,278        0.66       88.85
{txt}         60 {c |}{res}        732        0.15       89.00
{txt}       60.5 {c |}{res}      1,620        0.32       89.32
{txt}         61 {c |}{res}     10,082        2.02       91.34
{txt}       61.5 {c |}{res}        852        0.17       91.51
{txt}         62 {c |}{res}        396        0.08       91.59
{txt}       62.5 {c |}{res}      6,064        1.21       92.80
{txt}         63 {c |}{res}        745        0.15       92.95
{txt}       63.5 {c |}{res}      2,450        0.49       93.44
{txt}         64 {c |}{res}        577        0.12       93.55
{txt}       64.5 {c |}{res}        745        0.15       93.70
{txt}         65 {c |}{res}      3,102        0.62       94.32
{txt}       65.5 {c |}{res}        636        0.13       94.45
{txt}         66 {c |}{res}      5,463        1.09       95.54
{txt}         67 {c |}{res}      3,254        0.65       96.19
{txt}       67.5 {c |}{res}      2,339        0.47       96.66
{txt}         68 {c |}{res}      4,574        0.91       97.57
{txt}       68.5 {c |}{res}        984        0.20       97.77
{txt}         69 {c |}{res}        216        0.04       97.81
{txt}       69.5 {c |}{res}      1,260        0.25       98.07
{txt}         70 {c |}{res}         60        0.01       98.08
{txt}       70.5 {c |}{res}        276        0.06       98.13
{txt}         71 {c |}{res}        444        0.09       98.22
{txt}       71.5 {c |}{res}        481        0.10       98.32
{txt}         72 {c |}{res}        240        0.05       98.37
{txt}       72.5 {c |}{res}      1,620        0.32       98.69
{txt}         73 {c |}{res}         85        0.02       98.71
{txt}       73.5 {c |}{res}        432        0.09       98.79
{txt}       74.5 {c |}{res}        240        0.05       98.84
{txt}         75 {c |}{res}        673        0.13       98.98
{txt}       75.5 {c |}{res}         84        0.02       98.99
{txt}         76 {c |}{res}        156        0.03       99.02
{txt}       76.5 {c |}{res}        576        0.12       99.14
{txt}         77 {c |}{res}        205        0.04       99.18
{txt}         78 {c |}{res}        156        0.03       99.21
{txt}       78.5 {c |}{res}         84        0.02       99.23
{txt}         79 {c |}{res}         96        0.02       99.25
{txt}       79.5 {c |}{res}        156        0.03       99.28
{txt}       83.5 {c |}{res}         12        0.00       99.28
{txt}         85 {c |}{res}        156        0.03       99.31
{txt}         86 {c |}{res}         61        0.01       99.32
{txt}       88.5 {c |}{res}        120        0.02       99.35
{txt}         89 {c |}{res}        264        0.05       99.40
{txt}       91.5 {c |}{res}         96        0.02       99.42
{txt}       92.5 {c |}{res}         36        0.01       99.43
{txt}         96 {c |}{res}         13        0.00       99.43
{txt}       99.5 {c |}{res}         24        0.00       99.44
{txt}        100 {c |}{res}        652        0.13       99.57
{txt}        102 {c |}{res}        132        0.03       99.59
{txt}      103.5 {c |}{res}        144        0.03       99.62
{txt}        105 {c |}{res}        216        0.04       99.66
{txt}        108 {c |}{res}        144        0.03       99.69
{txt}        111 {c |}{res}        769        0.15       99.85
{txt}        114 {c |}{res}        180        0.04       99.88
{txt}      120.5 {c |}{res}        216        0.04       99.93
{txt}        122 {c |}{res}         84        0.02       99.94
{txt}      124.5 {c |}{res}        132        0.03       99.97
{txt}        127 {c |}{res}         96        0.02       99.99
{txt}        132 {c |}{res}         12        0.00       99.99
{txt}        143 {c |}{res}         48        0.01      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    500,065      100.00
{txt}
{com}. rename eei_bin eei_bin2 
{res}{txt}
{com}. label variable eei_bin2 "EEI in 0.5 bins" 
{txt}
{com}.         
.         
. *** bin construction  
.         * a 
. scalar int_a = 0.5 // steps
{txt}
{com}. scalar low_a = 1.25 // minimum
{txt}
{com}. scalar high_a = 16.25 // max 
{txt}
{com}.         * eei
. scalar int_e = 1 // steps --> this is the eei 
{txt}
{com}. scalar low_e = 13 // minimum
{txt}
{com}. scalar high_e = 143 
{txt}
{com}.         * s (rotated to flatten grid) 
. scalar int_s = 3 // steps
{txt}
{com}. scalar low_s = -255 // minimum (0 is compliance line)
{txt}
{com}. scalar high_s = 342 // max  
{txt}
{com}. 
. 
. ***************************************
. ** step 1: cut cells
. ***************************************
.         * 1a: capacity  
. egen a_bin=cut(capacity),at(`=low_a'(0.5)`=high_a')
{txt}
{com}. replace a_bin = a_bin + (`=int_a'/2) // name by midpoint. bin 4.25 is technically (4.251 to 4.749), rename so 4.5 is (4.251 to 4.749)
{txt}(500,065 real changes made)

{com}. 
. summ a_bin, detail 

                            {txt}a_bin
{hline 61}
      Percentiles      Smallest
 1%    {res}        4              3
{txt} 5%    {res}        5              3
{txt}10%    {res}        5              3       {txt}Obs         {res}    500,065
{txt}25%    {res}        6              3       {txt}Sum of wgt. {res}    500,065

{txt}50%    {res}        7                      {txt}Mean          {res} 6.649213
                        {txt}Largest       Std. dev.     {res} 1.238985
{txt}75%    {res}        7             15
{txt}90%    {res}        8             15       {txt}Variance      {res} 1.535083
{txt}95%    {res}        9             15       {txt}Skewness      {res} .6214532
{txt}99%    {res}       10             15       {txt}Kurtosis      {res} 5.016174
{txt}
{com}. codebook a_bin 

{txt}{hline}
{res}a_bin{right:(unlabeled)}
{txt}{hline}

{col 19}Type: Numeric ({res}float{txt})

{col 18}Range: [{res}3{txt},{res}15{txt}]{col 55}Units: {res}.1
{col 10}{txt}Unique values: {res}18{col 51}{txt}Missing .: {res}0{txt}/{res}500,065

{txt}{col 19}Mean: {res}{ralign 7:6.64921}
{txt}{col 14}Std. dev.: {res}{ralign 7:1.23898}

{txt}{col 12}Percentiles: {col 25}{ralign 7:10%}{ralign 10:25%}{ralign 10:50%}{ralign 10:75%}{ralign 10:90%}
{res}{col 25}{ralign 7:5}{ralign 10:       6}{ralign 10:       7}{ralign 10:       7}{ralign 10:       8}
{txt}
{com}.         * result: 18 cells of width 0.5 
.  
.         * 1b: kwh via eei 
.             * maximum e in cell is determined by a and eei.
. egen eei_bin=cut(eei),at(`=low_a'(1)`=high_a')
{txt}(499,900 missing values generated)

{com}. replace eei_bin = floor(eei_bin2)
{txt}(500,065 real changes made)

{com}. codebook eei_bin // 84 unique values  

{txt}{hline}
{res}eei_bin{right:(unlabeled)}
{txt}{hline}

{col 19}Type: Numeric ({res}float{txt})

{col 18}Range: [{res}13{txt},{res}143{txt}]{col 55}Units: {res}1
{col 10}{txt}Unique values: {res}84{col 51}{txt}Missing .: {res}0{txt}/{res}500,065

{txt}{col 19}Mean: {res}{ralign 7:49.8372}
{txt}{col 14}Std. dev.: {res}{ralign 7:10.4131}

{txt}{col 12}Percentiles: {col 25}{ralign 7:10%}{ralign 10:25%}{ralign 10:50%}{ralign 10:75%}{ralign 10:90%}
{res}{col 25}{ralign 7:38}{ralign 10:      44}{ralign 10:      50}{ralign 10:      57}{ralign 10:      61}
{txt}
{com}. 
. label variable eei_bin "EEI in 1-unit bins" // 84
{txt}
{com}. label variable eei_bin2 "EEI in 0.5-unit bins" // 133 
{txt}
{com}. 
.         * 1c: kwh in standardized version
.         
. egen s_bin=cut(s),at(`=low_s'(3)`=high_s') // set bins of width 3 kwh 
{txt}
{com}. 
. sum s if s_bin == -3 // bin range is -3 to 0 

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 11}s {c |}{res}     49,239   -1.384856    .8711056  -2.882999  -.0179994
{txt}
{com}. sum s if s_bin == 0 // 0 to 3

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 11}s {c |}{res}     13,244     1.05718    .8959505   .1170008   2.982001
{txt}
{com}. 
. tab s_bin if eei_bin == 58 // -3 and - 6

      {txt}s_bin {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
         -6 {c |}{res}        578        1.16        1.16
{txt}         -3 {c |}{res}     49,130       98.84      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}     49,708      100.00
{txt}
{com}. 
. tab s_bin if eei_bin == 57 // -9 -6 and -3 

      {txt}s_bin {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
         -9 {c |}{res}      4,721       24.25       24.25
{txt}         -6 {c |}{res}     14,635       75.19       99.44
{txt}         -3 {c |}{res}        109        0.56      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}     19,465      100.00
{txt}
{com}. tab s_bin if eei_bin == 59 // > 0. ok.  

      {txt}s_bin {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          0 {c |}{res}     13,244       98.57       98.57
{txt}          3 {c |}{res}        192        1.43      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}     13,436      100.00
{txt}
{com}. 
. *** store cell boundaries in local macros / scalars  ***
. sum a_bin, meanonly
{txt}
{com}. scalar max_a = `r(max)' 
{txt}
{com}. scalar min_a = `r(min)'
{txt}
{com}.         ** number of steps 
. scalar n_a = 1+ (`=max_a' - `=min_a')/0.5
{txt}
{com}. 
. *** e_bin based on eei (trapezoid cells)
. sum eei_bin, meanonly
{txt}
{com}. scalar max_eei = `r(max)'       
{txt}
{com}. scalar min_eei = `r(min)'
{txt}
{com}. scalar int_eei = 1
{txt}
{com}.         ** number of steps 
. scalar n_e = 1+ (`=max_eei' - `=min_eei')/`=int_eei'
{txt}
{com}. 
. *** s_bin (rectangular: compliance line at zero, cells of width = 3 kwh)
. sum s_bin, meanonly
{txt}
{com}. scalar max_s = `r(max)' 
{txt}
{com}. scalar min_s = `r(min)'
{txt}
{com}. scalar int_s = 3
{txt}
{com}.         ** number of steps 
. scalar n_s = 1+ (`=max_s' - `=min_s')/`=int_s'
{txt}
{com}.         *** save before proceeding 
. *cd "C:\Users\hy65byfe\Desktop\smerge_0712"
. *save spatial_0_raw_s, replace 
. 
. ********************************************
. *** expand to full grid (balanced panel) *** 
. 
. sort a_bin
{txt}
{com}. 
. gen ts = . // identifier for cells
{txt}(500,065 missing values generated)

{com}. gen added_a = 0 // tag added observations  
{txt}
{com}. 
. sum a_bin, meanonly
{txt}
{com}.         
. forvalues i=`=min_a'(0.5)`=max_a' {c -(}
{txt}  2{com}. replace ts= (2*(`i') - 5) if a_bin==`i' 
{txt}  3{com}.         * ex: 2*3 - 5 = 1 for smallest bin in range of capacities 
. {c )-}
{txt}(1,831 real changes made)
(3,043 real changes made)
(3,551 real changes made)
(4,021 real changes made)
(53,672 real changes made)
(21,180 real changes made)
(149,402 real changes made)
(4,487 real changes made)
(148,026 real changes made)
(156 real changes made)
(83,359 real changes made)
(0 real changes made)
(18,009 real changes made)
(0 real changes made)
(5,285 real changes made)
(0 real changes made)
(2,093 real changes made)
(0 real changes made)
(1,665 real changes made)
(0 real changes made)
(126 real changes made)
(0 real changes made)
(12 real changes made)
(0 real changes made)
(147 real changes made)

{com}. 
. 
. replace ts = 1 if ts == . // fix missings to avoid drop. 
{txt}(0 real changes made)

{com}. by ts, sort: gen panel_a=_n // running list of cell names
{txt}
{com}. tsset panel_a ts // set: 1 to 25 with gaps 
{res}
{col 1}{txt:Panel variable: }{res:panel_a}{txt: (unbalanced)}
{p 1 16 2}{txt:Time variable: }{res:ts}{txt:, }{res:{bind:1}}{txt: to }{res:{bind:25}}{txt:, but with gaps}{p_end}
{txt}{col 10}Delta: {res}1 unit
{txt}
{com}. tsfill // fill 
{txt}
{com}. tab ts // no gaps, range 1-25 (all available size brackets) 

         {txt}ts {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          1 {c |}{res}      1,831        0.23        0.23
{txt}          2 {c |}{res}      3,043        0.39        0.62
{txt}          3 {c |}{res}      3,551        0.45        1.07
{txt}          4 {c |}{res}      4,021        0.51        1.58
{txt}          5 {c |}{res}     53,672        6.82        8.40
{txt}          6 {c |}{res}     53,672        6.82       15.22
{txt}          7 {c |}{res}    149,402       18.98       34.21
{txt}          8 {c |}{res}    148,026       18.81       53.02
{txt}          9 {c |}{res}    148,026       18.81       71.83
{txt}         10 {c |}{res}     83,359       10.59       82.42
{txt}         11 {c |}{res}     83,359       10.59       93.01
{txt}         12 {c |}{res}     18,009        2.29       95.30
{txt}         13 {c |}{res}     18,009        2.29       97.59
{txt}         14 {c |}{res}      5,285        0.67       98.26
{txt}         15 {c |}{res}      5,285        0.67       98.93
{txt}         16 {c |}{res}      2,093        0.27       99.20
{txt}         17 {c |}{res}      2,093        0.27       99.46
{txt}         18 {c |}{res}      1,665        0.21       99.68
{txt}         19 {c |}{res}      1,665        0.21       99.89
{txt}         20 {c |}{res}        147        0.02       99.91
{txt}         21 {c |}{res}        147        0.02       99.93
{txt}         22 {c |}{res}        147        0.02       99.94
{txt}         23 {c |}{res}        147        0.02       99.96
{txt}         24 {c |}{res}        147        0.02       99.98
{txt}         25 {c |}{res}        147        0.02      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    786,948      100.00
{txt}
{com}. 
. by ts, sort: replace panel_a=_n
{txt}(786,916 real changes made)

{com}. replace added_a = 1 if added_a == . // identifies added observations 
{txt}(286,883 real changes made)

{com}. drop if panel_a > 1 & added_a == 1  // reduce to only 1 observation per added cell
{txt}(286,873 observations deleted)

{com}. 
. 
. gen a_binf = 0 
{txt}
{com}. summ ts, meanonly // only integers, continuous list 
{txt}
{com}.         
. forvalues i=`=r(min)'(1)`=r(max)' {c -(}
{txt}  2{com}. replace a_binf= (0.5*(`i') + 2.5) if ts==`i' 
{txt}  3{com}. {c )-}
{txt}(1,831 real changes made)
(3,043 real changes made)
(3,551 real changes made)
(4,021 real changes made)
(53,672 real changes made)
(21,180 real changes made)
(149,402 real changes made)
(4,488 real changes made)
(148,026 real changes made)
(157 real changes made)
(83,359 real changes made)
(1 real change made)
(18,009 real changes made)
(1 real change made)
(5,285 real changes made)
(1 real change made)
(2,093 real changes made)
(1 real change made)
(1,665 real changes made)
(1 real change made)
(126 real changes made)
(1 real change made)
(13 real changes made)
(1 real change made)
(147 real changes made)

{com}. 
. tab a_binf // all values  

     {txt}a_binf {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          3 {c |}{res}      1,831        0.37        0.37
{txt}        3.5 {c |}{res}      3,043        0.61        0.97
{txt}          4 {c |}{res}      3,551        0.71        1.68
{txt}        4.5 {c |}{res}      4,021        0.80        2.49
{txt}          5 {c |}{res}     53,672       10.73       13.22
{txt}        5.5 {c |}{res}     21,180        4.24       17.46
{txt}          6 {c |}{res}    149,402       29.88       47.33
{txt}        6.5 {c |}{res}      4,488        0.90       48.23
{txt}          7 {c |}{res}    148,026       29.60       77.83
{txt}        7.5 {c |}{res}        157        0.03       77.86
{txt}          8 {c |}{res}     83,359       16.67       94.53
{txt}        8.5 {c |}{res}          1        0.00       94.53
{txt}          9 {c |}{res}     18,009        3.60       98.13
{txt}        9.5 {c |}{res}          1        0.00       98.13
{txt}         10 {c |}{res}      5,285        1.06       99.19
{txt}       10.5 {c |}{res}          1        0.00       99.19
{txt}         11 {c |}{res}      2,093        0.42       99.61
{txt}       11.5 {c |}{res}          1        0.00       99.61
{txt}         12 {c |}{res}      1,665        0.33       99.94
{txt}       12.5 {c |}{res}          1        0.00       99.94
{txt}         13 {c |}{res}        126        0.03       99.97
{txt}       13.5 {c |}{res}          1        0.00       99.97
{txt}         14 {c |}{res}         13        0.00       99.97
{txt}       14.5 {c |}{res}          1        0.00       99.97
{txt}         15 {c |}{res}        147        0.03      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    500,075      100.00
{txt}
{com}. 
. replace a_bin = a_binf if added_a == 1 // replace from auxiliary to main variable 
{txt}(10 real changes made)

{com}.  
. tab a_bin

      {txt}a_bin {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          3 {c |}{res}      1,831        0.37        0.37
{txt}        3.5 {c |}{res}      3,043        0.61        0.97
{txt}          4 {c |}{res}      3,551        0.71        1.68
{txt}        4.5 {c |}{res}      4,021        0.80        2.49
{txt}          5 {c |}{res}     53,672       10.73       13.22
{txt}        5.5 {c |}{res}     21,180        4.24       17.46
{txt}          6 {c |}{res}    149,402       29.88       47.33
{txt}        6.5 {c |}{res}      4,488        0.90       48.23
{txt}          7 {c |}{res}    148,026       29.60       77.83
{txt}        7.5 {c |}{res}        157        0.03       77.86
{txt}          8 {c |}{res}     83,359       16.67       94.53
{txt}        8.5 {c |}{res}          1        0.00       94.53
{txt}          9 {c |}{res}     18,009        3.60       98.13
{txt}        9.5 {c |}{res}          1        0.00       98.13
{txt}         10 {c |}{res}      5,285        1.06       99.19
{txt}       10.5 {c |}{res}          1        0.00       99.19
{txt}         11 {c |}{res}      2,093        0.42       99.61
{txt}       11.5 {c |}{res}          1        0.00       99.61
{txt}         12 {c |}{res}      1,665        0.33       99.94
{txt}       12.5 {c |}{res}          1        0.00       99.94
{txt}         13 {c |}{res}        126        0.03       99.97
{txt}       13.5 {c |}{res}          1        0.00       99.97
{txt}         14 {c |}{res}         13        0.00       99.97
{txt}       14.5 {c |}{res}          1        0.00       99.97
{txt}         15 {c |}{res}        147        0.03      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    500,075      100.00
{txt}
{com}. 
. drop ts a_binf // drop aux. variables 
{txt}
{com}. 
. 
. ***** repeat for s_bin *****
. 
. sort s_bin
{txt}
{com}. 
. gen ts = . // identifier
{txt}(500,075 missing values generated)

{com}. gen added_s = 0 // tag added observations 
{txt}
{com}. 
. 
. summ s_bin, meanonly
{txt}
{com}.  
. forvalues i=`=min_s'(3)`=max_s' {c -(}
{txt}  2{com}. replace ts= ((`i')/ 3) if s_bin==`i' 
{txt}  3{com}.                 * ex: x/3 = 1 for smallest
. {c )-}
{txt}(63 real changes made)
(13 real changes made)
(0 real changes made)
(13 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(446 real changes made)
(0 real changes made)
(0 real changes made)
(52 real changes made)
(164 real changes made)
(0 real changes made)
(1 real change made)
(0 real changes made)
(0 real changes made)
(252 real changes made)
(112 real changes made)
(13 real changes made)
(319 real changes made)
(0 real changes made)
(39 real changes made)
(84 real changes made)
(1,033 real changes made)
(87 real changes made)
(0 real changes made)
(231 real changes made)
(689 real changes made)
(0 real changes made)
(0 real changes made)
(639 real changes made)
(775 real changes made)
(1 real change made)
(172 real changes made)
(348 real changes made)
(477 real changes made)
(2,002 real changes made)
(134 real changes made)
(722 real changes made)
(4,599 real changes made)
(1,001 real changes made)
(434 real changes made)
(3,169 real changes made)
(9,181 real changes made)
(552 real changes made)
(670 real changes made)
(2,471 real changes made)
(3,877 real changes made)
(399 real changes made)
(4,184 real changes made)
(1,661 real changes made)
(2,717 real changes made)
(1,364 real changes made)
(3,777 real changes made)
(3,381 real changes made)
(2,130 real changes made)
(7,244 real changes made)
(2,899 real changes made)
(2,820 real changes made)
(7,369 real changes made)
(19,584 real changes made)
(12,139 real changes made)
(25,314 real changes made)
(15,823 real changes made)
(18,942 real changes made)
(20,996 real changes made)
(14,667 real changes made)
(20,414 real changes made)
(4,295 real changes made)
(10,868 real changes made)
(3,823 real changes made)
(17,114 real changes made)
(21,952 real changes made)
(17,704 real changes made)
(23,061 real changes made)
(1,875 real changes made)
(3,486 real changes made)
(12,686 real changes made)
(9,256 real changes made)
(17,383 real changes made)
(15,466 real changes made)
(49,239 real changes made)
(13,244 real changes made)
(3,060 real changes made)
(10,142 real changes made)
(1,201 real changes made)
(7,566 real changes made)
(3,187 real changes made)
(9,134 real changes made)
(912 real changes made)
(1,047 real changes made)
(4,407 real changes made)
(3,660 real changes made)
(145 real changes made)
(936 real changes made)
(2,112 real changes made)
(444 real changes made)
(1,452 real changes made)
(336 real changes made)
(408 real changes made)
(877 real changes made)
(156 real changes made)
(48 real changes made)
(12 real changes made)
(588 real changes made)
(204 real changes made)
(240 real changes made)
(109 real changes made)
(0 real changes made)
(72 real changes made)
(120 real changes made)
(0 real changes made)
(61 real changes made)
(156 real changes made)
(36 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(168 real changes made)
(349 real changes made)
(216 real changes made)
(13 real changes made)
(120 real changes made)
(0 real changes made)
(0 real changes made)
(121 real changes made)
(288 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(182 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(985 real changes made)
(0 real changes made)
(84 real changes made)
(132 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(180 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(132 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(96 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(12 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(48 real changes made)

{com}. 
. 
. replace ts = 1 if ts == . // fix missings to avoid drop 
{txt}(10 real changes made)

{com}. by ts, sort: gen panel_s=_n // running list of cell names 
{txt}
{com}. tsset panel_s ts // list with gaps 
{res}
{col 1}{txt:Panel variable: }{res:panel_s}{txt: (unbalanced)}
{p 1 16 2}{txt:Time variable: }{res:ts}{txt:, }{res:{bind:-85}}{txt: to }{res:{bind:113}}{txt:, but with gaps}{p_end}
{txt}{col 10}Delta: {res}1 unit
{txt}
{com}. tsfill // fill 
{txt}
{com}. tab ts // no gaps.

         {txt}ts {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
        -85 {c |}{res}         63        0.01        0.01
{txt}        -84 {c |}{res}         63        0.01        0.01
{txt}        -83 {c |}{res}         63        0.01        0.02
{txt}        -82 {c |}{res}         63        0.01        0.03
{txt}        -81 {c |}{res}         63        0.01        0.03
{txt}        -80 {c |}{res}         63        0.01        0.04
{txt}        -79 {c |}{res}         63        0.01        0.05
{txt}        -78 {c |}{res}         63        0.01        0.06
{txt}        -77 {c |}{res}         63        0.01        0.06
{txt}        -76 {c |}{res}         63        0.01        0.07
{txt}        -75 {c |}{res}        446        0.05        0.12
{txt}        -74 {c |}{res}        446        0.05        0.17
{txt}        -73 {c |}{res}        446        0.05        0.22
{txt}        -72 {c |}{res}        446        0.05        0.26
{txt}        -71 {c |}{res}        446        0.05        0.31
{txt}        -70 {c |}{res}        446        0.05        0.36
{txt}        -69 {c |}{res}        446        0.05        0.41
{txt}        -68 {c |}{res}        446        0.05        0.46
{txt}        -67 {c |}{res}        446        0.05        0.51
{txt}        -66 {c |}{res}        446        0.05        0.56
{txt}        -65 {c |}{res}        446        0.05        0.61
{txt}        -64 {c |}{res}        446        0.05        0.65
{txt}        -63 {c |}{res}        446        0.05        0.70
{txt}        -62 {c |}{res}        446        0.05        0.75
{txt}        -61 {c |}{res}        446        0.05        0.80
{txt}        -60 {c |}{res}        446        0.05        0.85
{txt}        -59 {c |}{res}      1,033        0.11        0.96
{txt}        -58 {c |}{res}      1,033        0.11        1.07
{txt}        -57 {c |}{res}      1,033        0.11        1.19
{txt}        -56 {c |}{res}      1,033        0.11        1.30
{txt}        -55 {c |}{res}      1,033        0.11        1.41
{txt}        -54 {c |}{res}      1,033        0.11        1.53
{txt}        -53 {c |}{res}      1,033        0.11        1.64
{txt}        -52 {c |}{res}      1,033        0.11        1.75
{txt}        -51 {c |}{res}      1,033        0.11        1.87
{txt}        -50 {c |}{res}      1,033        0.11        1.98
{txt}        -49 {c |}{res}      1,033        0.11        2.09
{txt}        -48 {c |}{res}      1,033        0.11        2.20
{txt}        -47 {c |}{res}      1,033        0.11        2.32
{txt}        -46 {c |}{res}      2,002        0.22        2.54
{txt}        -45 {c |}{res}      2,002        0.22        2.76
{txt}        -44 {c |}{res}      2,002        0.22        2.97
{txt}        -43 {c |}{res}      4,599        0.50        3.48
{txt}        -42 {c |}{res}      4,599        0.50        3.98
{txt}        -41 {c |}{res}      4,599        0.50        4.48
{txt}        -40 {c |}{res}      4,599        0.50        4.99
{txt}        -39 {c |}{res}      9,181        1.00        5.99
{txt}        -38 {c |}{res}      9,181        1.00        6.99
{txt}        -37 {c |}{res}      9,181        1.00        8.00
{txt}        -36 {c |}{res}      9,181        1.00        9.00
{txt}        -35 {c |}{res}      9,181        1.00       10.00
{txt}        -34 {c |}{res}      9,181        1.00       11.01
{txt}        -33 {c |}{res}      9,181        1.00       12.01
{txt}        -32 {c |}{res}      9,181        1.00       13.02
{txt}        -31 {c |}{res}      9,181        1.00       14.02
{txt}        -30 {c |}{res}      9,181        1.00       15.02
{txt}        -29 {c |}{res}      9,181        1.00       16.03
{txt}        -28 {c |}{res}      9,181        1.00       17.03
{txt}        -27 {c |}{res}      9,181        1.00       18.03
{txt}        -26 {c |}{res}      9,181        1.00       19.04
{txt}        -25 {c |}{res}      9,181        1.00       20.04
{txt}        -24 {c |}{res}      9,181        1.00       21.05
{txt}        -23 {c |}{res}      9,181        1.00       22.05
{txt}        -22 {c |}{res}     19,584        2.14       24.19
{txt}        -21 {c |}{res}     19,584        2.14       26.33
{txt}        -20 {c |}{res}     25,314        2.77       29.10
{txt}        -19 {c |}{res}     25,314        2.77       31.87
{txt}        -18 {c |}{res}     25,314        2.77       34.63
{txt}        -17 {c |}{res}     25,314        2.77       37.40
{txt}        -16 {c |}{res}     25,314        2.77       40.17
{txt}        -15 {c |}{res}     25,314        2.77       42.94
{txt}        -14 {c |}{res}     25,314        2.77       45.71
{txt}        -13 {c |}{res}     25,314        2.77       48.47
{txt}        -12 {c |}{res}     25,314        2.77       51.24
{txt}        -11 {c |}{res}     25,314        2.77       54.01
{txt}        -10 {c |}{res}     25,314        2.77       56.78
{txt}         -9 {c |}{res}     25,314        2.77       59.54
{txt}         -8 {c |}{res}     25,314        2.77       62.31
{txt}         -7 {c |}{res}     25,314        2.77       65.08
{txt}         -6 {c |}{res}     25,314        2.77       67.85
{txt}         -5 {c |}{res}     25,314        2.77       70.61
{txt}         -4 {c |}{res}     25,314        2.77       73.38
{txt}         -3 {c |}{res}     25,314        2.77       76.15
{txt}         -2 {c |}{res}     25,314        2.77       78.92
{txt}         -1 {c |}{res}     49,239        5.38       84.30
{txt}          0 {c |}{res}     13,244        1.45       85.75
{txt}          1 {c |}{res}     10,142        1.11       86.86
{txt}          2 {c |}{res}     10,142        1.11       87.97
{txt}          3 {c |}{res}      9,134        1.00       88.97
{txt}          4 {c |}{res}      9,134        1.00       89.96
{txt}          5 {c |}{res}      9,134        1.00       90.96
{txt}          6 {c |}{res}      9,134        1.00       91.96
{txt}          7 {c |}{res}      4,407        0.48       92.44
{txt}          8 {c |}{res}      4,407        0.48       92.92
{txt}          9 {c |}{res}      4,407        0.48       93.41
{txt}         10 {c |}{res}      3,660        0.40       93.81
{txt}         11 {c |}{res}      2,112        0.23       94.04
{txt}         12 {c |}{res}      2,112        0.23       94.27
{txt}         13 {c |}{res}      2,112        0.23       94.50
{txt}         14 {c |}{res}      1,452        0.16       94.66
{txt}         15 {c |}{res}      1,452        0.16       94.82
{txt}         16 {c |}{res}        985        0.11       94.92
{txt}         17 {c |}{res}        985        0.11       95.03
{txt}         18 {c |}{res}        985        0.11       95.14
{txt}         19 {c |}{res}        985        0.11       95.25
{txt}         20 {c |}{res}        985        0.11       95.36
{txt}         21 {c |}{res}        985        0.11       95.46
{txt}         22 {c |}{res}        985        0.11       95.57
{txt}         23 {c |}{res}        985        0.11       95.68
{txt}         24 {c |}{res}        985        0.11       95.79
{txt}         25 {c |}{res}        985        0.11       95.89
{txt}         26 {c |}{res}        985        0.11       96.00
{txt}         27 {c |}{res}        985        0.11       96.11
{txt}         28 {c |}{res}        985        0.11       96.22
{txt}         29 {c |}{res}        985        0.11       96.32
{txt}         30 {c |}{res}        985        0.11       96.43
{txt}         31 {c |}{res}        985        0.11       96.54
{txt}         32 {c |}{res}        985        0.11       96.65
{txt}         33 {c |}{res}        985        0.11       96.76
{txt}         34 {c |}{res}        985        0.11       96.86
{txt}         35 {c |}{res}        985        0.11       96.97
{txt}         36 {c |}{res}        985        0.11       97.08
{txt}         37 {c |}{res}        985        0.11       97.19
{txt}         38 {c |}{res}        985        0.11       97.29
{txt}         39 {c |}{res}        985        0.11       97.40
{txt}         40 {c |}{res}        985        0.11       97.51
{txt}         41 {c |}{res}        985        0.11       97.62
{txt}         42 {c |}{res}        985        0.11       97.72
{txt}         43 {c |}{res}        985        0.11       97.83
{txt}         44 {c |}{res}        985        0.11       97.94
{txt}         45 {c |}{res}        985        0.11       98.05
{txt}         46 {c |}{res}        985        0.11       98.16
{txt}         47 {c |}{res}        985        0.11       98.26
{txt}         48 {c |}{res}        985        0.11       98.37
{txt}         49 {c |}{res}        985        0.11       98.48
{txt}         50 {c |}{res}        985        0.11       98.59
{txt}         51 {c |}{res}        985        0.11       98.69
{txt}         52 {c |}{res}        985        0.11       98.80
{txt}         53 {c |}{res}        985        0.11       98.91
{txt}         54 {c |}{res}        985        0.11       99.02
{txt}         55 {c |}{res}        985        0.11       99.12
{txt}         56 {c |}{res}        985        0.11       99.23
{txt}         57 {c |}{res}        985        0.11       99.34
{txt}         58 {c |}{res}        985        0.11       99.45
{txt}         59 {c |}{res}        180        0.02       99.47
{txt}         60 {c |}{res}        180        0.02       99.49
{txt}         61 {c |}{res}        180        0.02       99.51
{txt}         62 {c |}{res}        180        0.02       99.53
{txt}         63 {c |}{res}        180        0.02       99.55
{txt}         64 {c |}{res}        180        0.02       99.57
{txt}         65 {c |}{res}        180        0.02       99.59
{txt}         66 {c |}{res}        180        0.02       99.61
{txt}         67 {c |}{res}        180        0.02       99.62
{txt}         68 {c |}{res}        180        0.02       99.64
{txt}         69 {c |}{res}        180        0.02       99.66
{txt}         70 {c |}{res}        132        0.01       99.68
{txt}         71 {c |}{res}        132        0.01       99.69
{txt}         72 {c |}{res}        132        0.01       99.71
{txt}         73 {c |}{res}        132        0.01       99.72
{txt}         74 {c |}{res}         96        0.01       99.73
{txt}         75 {c |}{res}         96        0.01       99.74
{txt}         76 {c |}{res}         96        0.01       99.75
{txt}         77 {c |}{res}         96        0.01       99.76
{txt}         78 {c |}{res}         96        0.01       99.77
{txt}         79 {c |}{res}         96        0.01       99.78
{txt}         80 {c |}{res}         96        0.01       99.80
{txt}         81 {c |}{res}         96        0.01       99.81
{txt}         82 {c |}{res}         96        0.01       99.82
{txt}         83 {c |}{res}         96        0.01       99.83
{txt}         84 {c |}{res}         96        0.01       99.84
{txt}         85 {c |}{res}         96        0.01       99.85
{txt}         86 {c |}{res}         96        0.01       99.86
{txt}         87 {c |}{res}         48        0.01       99.86
{txt}         88 {c |}{res}         48        0.01       99.87
{txt}         89 {c |}{res}         48        0.01       99.87
{txt}         90 {c |}{res}         48        0.01       99.88
{txt}         91 {c |}{res}         48        0.01       99.88
{txt}         92 {c |}{res}         48        0.01       99.89
{txt}         93 {c |}{res}         48        0.01       99.90
{txt}         94 {c |}{res}         48        0.01       99.90
{txt}         95 {c |}{res}         48        0.01       99.91
{txt}         96 {c |}{res}         48        0.01       99.91
{txt}         97 {c |}{res}         48        0.01       99.92
{txt}         98 {c |}{res}         48        0.01       99.92
{txt}         99 {c |}{res}         48        0.01       99.93
{txt}        100 {c |}{res}         48        0.01       99.93
{txt}        101 {c |}{res}         48        0.01       99.94
{txt}        102 {c |}{res}         48        0.01       99.94
{txt}        103 {c |}{res}         48        0.01       99.95
{txt}        104 {c |}{res}         48        0.01       99.95
{txt}        105 {c |}{res}         48        0.01       99.96
{txt}        106 {c |}{res}         48        0.01       99.96
{txt}        107 {c |}{res}         48        0.01       99.97
{txt}        108 {c |}{res}         48        0.01       99.97
{txt}        109 {c |}{res}         48        0.01       99.98
{txt}        110 {c |}{res}         48        0.01       99.98
{txt}        111 {c |}{res}         48        0.01       99.99
{txt}        112 {c |}{res}         48        0.01       99.99
{txt}        113 {c |}{res}         48        0.01      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    914,639      100.00
{txt}
{com}. by ts, sort: replace panel_s=_n
{txt}(914,427 real changes made)

{com}. replace added_s = 1 if added_s == . // identifies added observations 
{txt}(414,564 real changes made)

{com}. drop if panel_s > 1 & added_s == 1  // reduce to only 1 observation per added cell 
{txt}(414,422 observations deleted)

{com}. 
. 
. gen s_binf = 0 
{txt}
{com}. summ ts, meanonly // only integers
{txt}
{com}.         
. forvalues i=`=r(min)'(1)`=r(max)' {c -(}
{txt}  2{com}. replace s_binf= ((`i')*3) if ts==`i' 
{txt}  3{com}. {c )-}
{txt}(63 real changes made)
(14 real changes made)
(1 real change made)
(14 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(446 real changes made)
(1 real change made)
(1 real change made)
(52 real changes made)
(165 real changes made)
(1 real change made)
(2 real changes made)
(1 real change made)
(1 real change made)
(253 real changes made)
(112 real changes made)
(14 real changes made)
(319 real changes made)
(1 real change made)
(40 real changes made)
(84 real changes made)
(1,033 real changes made)
(88 real changes made)
(1 real change made)
(232 real changes made)
(690 real changes made)
(1 real change made)
(1 real change made)
(640 real changes made)
(775 real changes made)
(2 real changes made)
(173 real changes made)
(349 real changes made)
(477 real changes made)
(2,002 real changes made)
(135 real changes made)
(723 real changes made)
(4,599 real changes made)
(1,002 real changes made)
(435 real changes made)
(3,170 real changes made)
(9,181 real changes made)
(553 real changes made)
(671 real changes made)
(2,472 real changes made)
(3,877 real changes made)
(400 real changes made)
(4,185 real changes made)
(1,662 real changes made)
(2,717 real changes made)
(1,365 real changes made)
(3,777 real changes made)
(3,382 real changes made)
(2,131 real changes made)
(7,244 real changes made)
(2,900 real changes made)
(2,820 real changes made)
(7,370 real changes made)
(19,584 real changes made)
(12,139 real changes made)
(25,314 real changes made)
(15,823 real changes made)
(18,942 real changes made)
(20,996 real changes made)
(14,667 real changes made)
(20,414 real changes made)
(4,295 real changes made)
(10,869 real changes made)
(3,824 real changes made)
(17,114 real changes made)
(21,952 real changes made)
(17,704 real changes made)
(23,061 real changes made)
(1,876 real changes made)
(3,487 real changes made)
(12,686 real changes made)
(9,256 real changes made)
(17,383 real changes made)
(15,466 real changes made)
(49,239 real changes made)
(0 real changes made)
(3,071 real changes made)
(10,142 real changes made)
(1,202 real changes made)
(7,566 real changes made)
(3,188 real changes made)
(9,134 real changes made)
(913 real changes made)
(1,048 real changes made)
(4,407 real changes made)
(3,660 real changes made)
(146 real changes made)
(937 real changes made)
(2,112 real changes made)
(444 real changes made)
(1,452 real changes made)
(336 real changes made)
(409 real changes made)
(878 real changes made)
(157 real changes made)
(49 real changes made)
(13 real changes made)
(588 real changes made)
(205 real changes made)
(241 real changes made)
(110 real changes made)
(1 real change made)
(73 real changes made)
(121 real changes made)
(1 real change made)
(62 real changes made)
(157 real changes made)
(37 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(168 real changes made)
(350 real changes made)
(216 real changes made)
(14 real changes made)
(120 real changes made)
(1 real change made)
(1 real change made)
(122 real changes made)
(288 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(183 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(985 real changes made)
(1 real change made)
(84 real changes made)
(132 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(180 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(132 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(96 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(13 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(48 real changes made)

{com}. 
. tab s_binf // complete list  

     {txt}s_binf {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
       -255 {c |}{res}         63        0.01        0.01
{txt}       -252 {c |}{res}         14        0.00        0.02
{txt}       -249 {c |}{res}          1        0.00        0.02
{txt}       -246 {c |}{res}         14        0.00        0.02
{txt}       -243 {c |}{res}          1        0.00        0.02
{txt}       -240 {c |}{res}          1        0.00        0.02
{txt}       -237 {c |}{res}          1        0.00        0.02
{txt}       -234 {c |}{res}          1        0.00        0.02
{txt}       -231 {c |}{res}          1        0.00        0.02
{txt}       -228 {c |}{res}          1        0.00        0.02
{txt}       -225 {c |}{res}        446        0.09        0.11
{txt}       -222 {c |}{res}          1        0.00        0.11
{txt}       -219 {c |}{res}          1        0.00        0.11
{txt}       -216 {c |}{res}         52        0.01        0.12
{txt}       -213 {c |}{res}        165        0.03        0.15
{txt}       -210 {c |}{res}          1        0.00        0.15
{txt}       -207 {c |}{res}          2        0.00        0.15
{txt}       -204 {c |}{res}          1        0.00        0.15
{txt}       -201 {c |}{res}          1        0.00        0.15
{txt}       -198 {c |}{res}        253        0.05        0.20
{txt}       -195 {c |}{res}        112        0.02        0.23
{txt}       -192 {c |}{res}         14        0.00        0.23
{txt}       -189 {c |}{res}        319        0.06        0.29
{txt}       -186 {c |}{res}          1        0.00        0.29
{txt}       -183 {c |}{res}         40        0.01        0.30
{txt}       -180 {c |}{res}         84        0.02        0.32
{txt}       -177 {c |}{res}      1,033        0.21        0.52
{txt}       -174 {c |}{res}         88        0.02        0.54
{txt}       -171 {c |}{res}          1        0.00        0.54
{txt}       -168 {c |}{res}        232        0.05        0.59
{txt}       -165 {c |}{res}        690        0.14        0.73
{txt}       -162 {c |}{res}          1        0.00        0.73
{txt}       -159 {c |}{res}          1        0.00        0.73
{txt}       -156 {c |}{res}        640        0.13        0.86
{txt}       -153 {c |}{res}        775        0.15        1.01
{txt}       -150 {c |}{res}          2        0.00        1.01
{txt}       -147 {c |}{res}        173        0.03        1.04
{txt}       -144 {c |}{res}        349        0.07        1.11
{txt}       -141 {c |}{res}        477        0.10        1.21
{txt}       -138 {c |}{res}      2,002        0.40        1.61
{txt}       -135 {c |}{res}        135        0.03        1.64
{txt}       -132 {c |}{res}        723        0.14        1.78
{txt}       -129 {c |}{res}      4,599        0.92        2.70
{txt}       -126 {c |}{res}      1,002        0.20        2.90
{txt}       -123 {c |}{res}        435        0.09        2.99
{txt}       -120 {c |}{res}      3,170        0.63        3.62
{txt}       -117 {c |}{res}      9,181        1.84        5.46
{txt}       -114 {c |}{res}        553        0.11        5.57
{txt}       -111 {c |}{res}        671        0.13        5.70
{txt}       -108 {c |}{res}      2,472        0.49        6.20
{txt}       -105 {c |}{res}      3,877        0.78        6.97
{txt}       -102 {c |}{res}        400        0.08        7.05
{txt}        -99 {c |}{res}      4,185        0.84        7.89
{txt}        -96 {c |}{res}      1,662        0.33        8.22
{txt}        -93 {c |}{res}      2,717        0.54        8.76
{txt}        -90 {c |}{res}      1,365        0.27        9.04
{txt}        -87 {c |}{res}      3,777        0.76        9.79
{txt}        -84 {c |}{res}      3,382        0.68       10.47
{txt}        -81 {c |}{res}      2,131        0.43       10.89
{txt}        -78 {c |}{res}      7,244        1.45       12.34
{txt}        -75 {c |}{res}      2,900        0.58       12.92
{txt}        -72 {c |}{res}      2,820        0.56       13.49
{txt}        -69 {c |}{res}      7,370        1.47       14.96
{txt}        -66 {c |}{res}     19,584        3.92       18.87
{txt}        -63 {c |}{res}     12,139        2.43       21.30
{txt}        -60 {c |}{res}     25,314        5.06       26.36
{txt}        -57 {c |}{res}     15,823        3.16       29.52
{txt}        -54 {c |}{res}     18,942        3.79       33.31
{txt}        -51 {c |}{res}     20,996        4.20       37.51
{txt}        -48 {c |}{res}     14,667        2.93       40.44
{txt}        -45 {c |}{res}     20,414        4.08       44.52
{txt}        -42 {c |}{res}      4,295        0.86       45.38
{txt}        -39 {c |}{res}     10,869        2.17       47.55
{txt}        -36 {c |}{res}      3,824        0.76       48.32
{txt}        -33 {c |}{res}     17,114        3.42       51.74
{txt}        -30 {c |}{res}     21,952        4.39       56.13
{txt}        -27 {c |}{res}     17,704        3.54       59.67
{txt}        -24 {c |}{res}     23,061        4.61       64.28
{txt}        -21 {c |}{res}      1,876        0.38       64.65
{txt}        -18 {c |}{res}      3,487        0.70       65.35
{txt}        -15 {c |}{res}     12,686        2.54       67.89
{txt}        -12 {c |}{res}      9,256        1.85       69.74
{txt}         -9 {c |}{res}     17,383        3.48       73.21
{txt}         -6 {c |}{res}     15,466        3.09       76.30
{txt}         -3 {c |}{res}     49,239        9.84       86.15
{txt}          0 {c |}{res}     13,244        2.65       88.79
{txt}          3 {c |}{res}      3,071        0.61       89.41
{txt}          6 {c |}{res}     10,142        2.03       91.44
{txt}          9 {c |}{res}      1,202        0.24       91.68
{txt}         12 {c |}{res}      7,566        1.51       93.19
{txt}         15 {c |}{res}      3,188        0.64       93.83
{txt}         18 {c |}{res}      9,134        1.83       95.65
{txt}         21 {c |}{res}        913        0.18       95.83
{txt}         24 {c |}{res}      1,048        0.21       96.04
{txt}         27 {c |}{res}      4,407        0.88       96.92
{txt}         30 {c |}{res}      3,660        0.73       97.66
{txt}         33 {c |}{res}        146        0.03       97.69
{txt}         36 {c |}{res}        937        0.19       97.87
{txt}         39 {c |}{res}      2,112        0.42       98.29
{txt}         42 {c |}{res}        444        0.09       98.38
{txt}         45 {c |}{res}      1,452        0.29       98.67
{txt}         48 {c |}{res}        336        0.07       98.74
{txt}         51 {c |}{res}        409        0.08       98.82
{txt}         54 {c |}{res}        878        0.18       99.00
{txt}         57 {c |}{res}        157        0.03       99.03
{txt}         60 {c |}{res}         49        0.01       99.04
{txt}         63 {c |}{res}         13        0.00       99.04
{txt}         66 {c |}{res}        588        0.12       99.16
{txt}         69 {c |}{res}        205        0.04       99.20
{txt}         72 {c |}{res}        241        0.05       99.25
{txt}         75 {c |}{res}        110        0.02       99.27
{txt}         78 {c |}{res}          1        0.00       99.27
{txt}         81 {c |}{res}         73        0.01       99.29
{txt}         84 {c |}{res}        121        0.02       99.31
{txt}         87 {c |}{res}          1        0.00       99.31
{txt}         90 {c |}{res}         62        0.01       99.32
{txt}         93 {c |}{res}        157        0.03       99.35
{txt}         96 {c |}{res}         37        0.01       99.36
{txt}         99 {c |}{res}          1        0.00       99.36
{txt}        102 {c |}{res}          1        0.00       99.36
{txt}        105 {c |}{res}          1        0.00       99.36
{txt}        108 {c |}{res}          1        0.00       99.36
{txt}        111 {c |}{res}          1        0.00       99.36
{txt}        114 {c |}{res}        168        0.03       99.40
{txt}        117 {c |}{res}        350        0.07       99.47
{txt}        120 {c |}{res}        216        0.04       99.51
{txt}        123 {c |}{res}         14        0.00       99.51
{txt}        126 {c |}{res}        120        0.02       99.54
{txt}        129 {c |}{res}          1        0.00       99.54
{txt}        132 {c |}{res}          1        0.00       99.54
{txt}        135 {c |}{res}        122        0.02       99.56
{txt}        138 {c |}{res}        288        0.06       99.62
{txt}        141 {c |}{res}          1        0.00       99.62
{txt}        144 {c |}{res}          1        0.00       99.62
{txt}        147 {c |}{res}          1        0.00       99.62
{txt}        150 {c |}{res}          1        0.00       99.62
{txt}        153 {c |}{res}          1        0.00       99.62
{txt}        156 {c |}{res}        183        0.04       99.66
{txt}        159 {c |}{res}          1        0.00       99.66
{txt}        162 {c |}{res}          1        0.00       99.66
{txt}        165 {c |}{res}          1        0.00       99.66
{txt}        168 {c |}{res}          1        0.00       99.66
{txt}        171 {c |}{res}          1        0.00       99.66
{txt}        174 {c |}{res}        985        0.20       99.85
{txt}        177 {c |}{res}          1        0.00       99.85
{txt}        180 {c |}{res}         84        0.02       99.87
{txt}        183 {c |}{res}        132        0.03       99.90
{txt}        186 {c |}{res}          1        0.00       99.90
{txt}        189 {c |}{res}          1        0.00       99.90
{txt}        192 {c |}{res}          1        0.00       99.90
{txt}        195 {c |}{res}          1        0.00       99.90
{txt}        198 {c |}{res}          1        0.00       99.90
{txt}        201 {c |}{res}          1        0.00       99.90
{txt}        204 {c |}{res}          1        0.00       99.90
{txt}        207 {c |}{res}        180        0.04       99.93
{txt}        210 {c |}{res}          1        0.00       99.93
{txt}        213 {c |}{res}          1        0.00       99.93
{txt}        216 {c |}{res}          1        0.00       99.93
{txt}        219 {c |}{res}        132        0.03       99.96
{txt}        222 {c |}{res}          1        0.00       99.96
{txt}        225 {c |}{res}          1        0.00       99.96
{txt}        228 {c |}{res}          1        0.00       99.96
{txt}        231 {c |}{res}          1        0.00       99.96
{txt}        234 {c |}{res}          1        0.00       99.96
{txt}        237 {c |}{res}          1        0.00       99.96
{txt}        240 {c |}{res}          1        0.00       99.96
{txt}        243 {c |}{res}          1        0.00       99.96
{txt}        246 {c |}{res}          1        0.00       99.96
{txt}        249 {c |}{res}          1        0.00       99.96
{txt}        252 {c |}{res}          1        0.00       99.96
{txt}        255 {c |}{res}          1        0.00       99.96
{txt}        258 {c |}{res}         96        0.02       99.98
{txt}        261 {c |}{res}          1        0.00       99.98
{txt}        264 {c |}{res}          1        0.00       99.98
{txt}        267 {c |}{res}          1        0.00       99.98
{txt}        270 {c |}{res}          1        0.00       99.98
{txt}        273 {c |}{res}          1        0.00       99.98
{txt}        276 {c |}{res}          1        0.00       99.98
{txt}        279 {c |}{res}         13        0.00       99.99
{txt}        282 {c |}{res}          1        0.00       99.99
{txt}        285 {c |}{res}          1        0.00       99.99
{txt}        288 {c |}{res}          1        0.00       99.99
{txt}        291 {c |}{res}          1        0.00       99.99
{txt}        294 {c |}{res}          1        0.00       99.99
{txt}        297 {c |}{res}          1        0.00       99.99
{txt}        300 {c |}{res}          1        0.00       99.99
{txt}        303 {c |}{res}          1        0.00       99.99
{txt}        306 {c |}{res}          1        0.00       99.99
{txt}        309 {c |}{res}          1        0.00       99.99
{txt}        312 {c |}{res}          1        0.00       99.99
{txt}        315 {c |}{res}          1        0.00       99.99
{txt}        318 {c |}{res}          1        0.00       99.99
{txt}        321 {c |}{res}          1        0.00       99.99
{txt}        324 {c |}{res}          1        0.00       99.99
{txt}        327 {c |}{res}          1        0.00       99.99
{txt}        330 {c |}{res}          1        0.00       99.99
{txt}        333 {c |}{res}          1        0.00       99.99
{txt}        336 {c |}{res}          1        0.00       99.99
{txt}        339 {c |}{res}         48        0.01      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    500,217      100.00
{txt}
{com}. 
. replace s_bin = s_binf if added_s == 1 // fill from aux. variable  
{txt}(142 real changes made)

{com}.  
. tab s_bin

      {txt}s_bin {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
       -255 {c |}{res}         63        0.01        0.01
{txt}       -252 {c |}{res}         14        0.00        0.02
{txt}       -249 {c |}{res}          1        0.00        0.02
{txt}       -246 {c |}{res}         14        0.00        0.02
{txt}       -243 {c |}{res}          1        0.00        0.02
{txt}       -240 {c |}{res}          1        0.00        0.02
{txt}       -237 {c |}{res}          1        0.00        0.02
{txt}       -234 {c |}{res}          1        0.00        0.02
{txt}       -231 {c |}{res}          1        0.00        0.02
{txt}       -228 {c |}{res}          1        0.00        0.02
{txt}       -225 {c |}{res}        446        0.09        0.11
{txt}       -222 {c |}{res}          1        0.00        0.11
{txt}       -219 {c |}{res}          1        0.00        0.11
{txt}       -216 {c |}{res}         52        0.01        0.12
{txt}       -213 {c |}{res}        165        0.03        0.15
{txt}       -210 {c |}{res}          1        0.00        0.15
{txt}       -207 {c |}{res}          2        0.00        0.15
{txt}       -204 {c |}{res}          1        0.00        0.15
{txt}       -201 {c |}{res}          1        0.00        0.15
{txt}       -198 {c |}{res}        253        0.05        0.20
{txt}       -195 {c |}{res}        112        0.02        0.23
{txt}       -192 {c |}{res}         14        0.00        0.23
{txt}       -189 {c |}{res}        319        0.06        0.29
{txt}       -186 {c |}{res}          1        0.00        0.29
{txt}       -183 {c |}{res}         40        0.01        0.30
{txt}       -180 {c |}{res}         84        0.02        0.32
{txt}       -177 {c |}{res}      1,033        0.21        0.52
{txt}       -174 {c |}{res}         88        0.02        0.54
{txt}       -171 {c |}{res}          1        0.00        0.54
{txt}       -168 {c |}{res}        232        0.05        0.59
{txt}       -165 {c |}{res}        690        0.14        0.73
{txt}       -162 {c |}{res}          1        0.00        0.73
{txt}       -159 {c |}{res}          1        0.00        0.73
{txt}       -156 {c |}{res}        640        0.13        0.86
{txt}       -153 {c |}{res}        775        0.15        1.01
{txt}       -150 {c |}{res}          2        0.00        1.01
{txt}       -147 {c |}{res}        173        0.03        1.04
{txt}       -144 {c |}{res}        349        0.07        1.11
{txt}       -141 {c |}{res}        477        0.10        1.21
{txt}       -138 {c |}{res}      2,002        0.40        1.61
{txt}       -135 {c |}{res}        135        0.03        1.64
{txt}       -132 {c |}{res}        723        0.14        1.78
{txt}       -129 {c |}{res}      4,599        0.92        2.70
{txt}       -126 {c |}{res}      1,002        0.20        2.90
{txt}       -123 {c |}{res}        435        0.09        2.99
{txt}       -120 {c |}{res}      3,170        0.63        3.62
{txt}       -117 {c |}{res}      9,181        1.84        5.46
{txt}       -114 {c |}{res}        553        0.11        5.57
{txt}       -111 {c |}{res}        671        0.13        5.70
{txt}       -108 {c |}{res}      2,472        0.49        6.20
{txt}       -105 {c |}{res}      3,877        0.78        6.97
{txt}       -102 {c |}{res}        400        0.08        7.05
{txt}        -99 {c |}{res}      4,185        0.84        7.89
{txt}        -96 {c |}{res}      1,662        0.33        8.22
{txt}        -93 {c |}{res}      2,717        0.54        8.76
{txt}        -90 {c |}{res}      1,365        0.27        9.04
{txt}        -87 {c |}{res}      3,777        0.76        9.79
{txt}        -84 {c |}{res}      3,382        0.68       10.47
{txt}        -81 {c |}{res}      2,131        0.43       10.89
{txt}        -78 {c |}{res}      7,244        1.45       12.34
{txt}        -75 {c |}{res}      2,900        0.58       12.92
{txt}        -72 {c |}{res}      2,820        0.56       13.49
{txt}        -69 {c |}{res}      7,370        1.47       14.96
{txt}        -66 {c |}{res}     19,584        3.92       18.87
{txt}        -63 {c |}{res}     12,139        2.43       21.30
{txt}        -60 {c |}{res}     25,314        5.06       26.36
{txt}        -57 {c |}{res}     15,823        3.16       29.52
{txt}        -54 {c |}{res}     18,942        3.79       33.31
{txt}        -51 {c |}{res}     20,996        4.20       37.51
{txt}        -48 {c |}{res}     14,667        2.93       40.44
{txt}        -45 {c |}{res}     20,414        4.08       44.52
{txt}        -42 {c |}{res}      4,295        0.86       45.38
{txt}        -39 {c |}{res}     10,869        2.17       47.55
{txt}        -36 {c |}{res}      3,824        0.76       48.32
{txt}        -33 {c |}{res}     17,114        3.42       51.74
{txt}        -30 {c |}{res}     21,952        4.39       56.13
{txt}        -27 {c |}{res}     17,704        3.54       59.67
{txt}        -24 {c |}{res}     23,061        4.61       64.28
{txt}        -21 {c |}{res}      1,876        0.38       64.65
{txt}        -18 {c |}{res}      3,487        0.70       65.35
{txt}        -15 {c |}{res}     12,686        2.54       67.89
{txt}        -12 {c |}{res}      9,256        1.85       69.74
{txt}         -9 {c |}{res}     17,383        3.48       73.21
{txt}         -6 {c |}{res}     15,466        3.09       76.30
{txt}         -3 {c |}{res}     49,239        9.84       86.15
{txt}          0 {c |}{res}     13,244        2.65       88.80
{txt}          3 {c |}{res}      3,061        0.61       89.41
{txt}          6 {c |}{res}     10,142        2.03       91.43
{txt}          9 {c |}{res}      1,202        0.24       91.68
{txt}         12 {c |}{res}      7,566        1.51       93.19
{txt}         15 {c |}{res}      3,188        0.64       93.83
{txt}         18 {c |}{res}      9,134        1.83       95.65
{txt}         21 {c |}{res}        913        0.18       95.83
{txt}         24 {c |}{res}      1,048        0.21       96.04
{txt}         27 {c |}{res}      4,407        0.88       96.92
{txt}         30 {c |}{res}      3,660        0.73       97.66
{txt}         33 {c |}{res}        146        0.03       97.69
{txt}         36 {c |}{res}        937        0.19       97.87
{txt}         39 {c |}{res}      2,112        0.42       98.29
{txt}         42 {c |}{res}        444        0.09       98.38
{txt}         45 {c |}{res}      1,452        0.29       98.67
{txt}         48 {c |}{res}        336        0.07       98.74
{txt}         51 {c |}{res}        409        0.08       98.82
{txt}         54 {c |}{res}        878        0.18       99.00
{txt}         57 {c |}{res}        157        0.03       99.03
{txt}         60 {c |}{res}         49        0.01       99.04
{txt}         63 {c |}{res}         13        0.00       99.04
{txt}         66 {c |}{res}        588        0.12       99.16
{txt}         69 {c |}{res}        205        0.04       99.20
{txt}         72 {c |}{res}        241        0.05       99.25
{txt}         75 {c |}{res}        110        0.02       99.27
{txt}         78 {c |}{res}          1        0.00       99.27
{txt}         81 {c |}{res}         73        0.01       99.29
{txt}         84 {c |}{res}        121        0.02       99.31
{txt}         87 {c |}{res}          1        0.00       99.31
{txt}         90 {c |}{res}         62        0.01       99.32
{txt}         93 {c |}{res}        157        0.03       99.35
{txt}         96 {c |}{res}         37        0.01       99.36
{txt}         99 {c |}{res}          1        0.00       99.36
{txt}        102 {c |}{res}          1        0.00       99.36
{txt}        105 {c |}{res}          1        0.00       99.36
{txt}        108 {c |}{res}          1        0.00       99.36
{txt}        111 {c |}{res}          1        0.00       99.36
{txt}        114 {c |}{res}        168        0.03       99.40
{txt}        117 {c |}{res}        350        0.07       99.47
{txt}        120 {c |}{res}        216        0.04       99.51
{txt}        123 {c |}{res}         14        0.00       99.51
{txt}        126 {c |}{res}        120        0.02       99.54
{txt}        129 {c |}{res}          1        0.00       99.54
{txt}        132 {c |}{res}          1        0.00       99.54
{txt}        135 {c |}{res}        122        0.02       99.56
{txt}        138 {c |}{res}        288        0.06       99.62
{txt}        141 {c |}{res}          1        0.00       99.62
{txt}        144 {c |}{res}          1        0.00       99.62
{txt}        147 {c |}{res}          1        0.00       99.62
{txt}        150 {c |}{res}          1        0.00       99.62
{txt}        153 {c |}{res}          1        0.00       99.62
{txt}        156 {c |}{res}        183        0.04       99.66
{txt}        159 {c |}{res}          1        0.00       99.66
{txt}        162 {c |}{res}          1        0.00       99.66
{txt}        165 {c |}{res}          1        0.00       99.66
{txt}        168 {c |}{res}          1        0.00       99.66
{txt}        171 {c |}{res}          1        0.00       99.66
{txt}        174 {c |}{res}        985        0.20       99.85
{txt}        177 {c |}{res}          1        0.00       99.85
{txt}        180 {c |}{res}         84        0.02       99.87
{txt}        183 {c |}{res}        132        0.03       99.90
{txt}        186 {c |}{res}          1        0.00       99.90
{txt}        189 {c |}{res}          1        0.00       99.90
{txt}        192 {c |}{res}          1        0.00       99.90
{txt}        195 {c |}{res}          1        0.00       99.90
{txt}        198 {c |}{res}          1        0.00       99.90
{txt}        201 {c |}{res}          1        0.00       99.90
{txt}        204 {c |}{res}          1        0.00       99.90
{txt}        207 {c |}{res}        180        0.04       99.93
{txt}        210 {c |}{res}          1        0.00       99.93
{txt}        213 {c |}{res}          1        0.00       99.93
{txt}        216 {c |}{res}          1        0.00       99.93
{txt}        219 {c |}{res}        132        0.03       99.96
{txt}        222 {c |}{res}          1        0.00       99.96
{txt}        225 {c |}{res}          1        0.00       99.96
{txt}        228 {c |}{res}          1        0.00       99.96
{txt}        231 {c |}{res}          1        0.00       99.96
{txt}        234 {c |}{res}          1        0.00       99.96
{txt}        237 {c |}{res}          1        0.00       99.96
{txt}        240 {c |}{res}          1        0.00       99.96
{txt}        243 {c |}{res}          1        0.00       99.96
{txt}        246 {c |}{res}          1        0.00       99.96
{txt}        249 {c |}{res}          1        0.00       99.96
{txt}        252 {c |}{res}          1        0.00       99.96
{txt}        255 {c |}{res}          1        0.00       99.96
{txt}        258 {c |}{res}         96        0.02       99.98
{txt}        261 {c |}{res}          1        0.00       99.98
{txt}        264 {c |}{res}          1        0.00       99.98
{txt}        267 {c |}{res}          1        0.00       99.98
{txt}        270 {c |}{res}          1        0.00       99.98
{txt}        273 {c |}{res}          1        0.00       99.98
{txt}        276 {c |}{res}          1        0.00       99.98
{txt}        279 {c |}{res}         13        0.00       99.99
{txt}        282 {c |}{res}          1        0.00       99.99
{txt}        285 {c |}{res}          1        0.00       99.99
{txt}        288 {c |}{res}          1        0.00       99.99
{txt}        291 {c |}{res}          1        0.00       99.99
{txt}        294 {c |}{res}          1        0.00       99.99
{txt}        297 {c |}{res}          1        0.00       99.99
{txt}        300 {c |}{res}          1        0.00       99.99
{txt}        303 {c |}{res}          1        0.00       99.99
{txt}        306 {c |}{res}          1        0.00       99.99
{txt}        309 {c |}{res}          1        0.00       99.99
{txt}        312 {c |}{res}          1        0.00       99.99
{txt}        315 {c |}{res}          1        0.00       99.99
{txt}        318 {c |}{res}          1        0.00       99.99
{txt}        321 {c |}{res}          1        0.00       99.99
{txt}        324 {c |}{res}          1        0.00       99.99
{txt}        327 {c |}{res}          1        0.00       99.99
{txt}        330 {c |}{res}          1        0.00       99.99
{txt}        333 {c |}{res}          1        0.00       99.99
{txt}        336 {c |}{res}          1        0.00       99.99
{txt}        339 {c |}{res}         48        0.01      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    500,207      100.00
{txt}
{com}. 
. drop ts s_binf // drop aux. variable 
{txt}
{com}. 
. 
.         *** e in kwh/year, assignment via eei *** 
. sort eei_bin
{txt}
{com}. 
. gen ts = . // identifier 
{txt}(500,217 missing values generated)

{com}. gen added_eei = 0  // tag 
{txt}
{com}. 
. summ eei_bin, meanonly
{txt}
{com}. 
. forvalues i=`=min_eei'(1)`=max_eei' {c -(} 
{txt}  2{com}.         replace ts= (2*(`i') - 25) if eei_bin==`i' 
{txt}  3{com}. {c )-}
{txt}(164 real changes made)
(0 real changes made)
(0 real changes made)
(1 real change made)
(63 real changes made)
(177 real changes made)
(13 real changes made)
(518 real changes made)
(0 real changes made)
(2,510 real changes made)
(0 real changes made)
(0 real changes made)
(99 real changes made)
(365 real changes made)
(3,658 real changes made)
(157 real changes made)
(1,051 real changes made)
(26 real changes made)
(3,596 real changes made)
(16,678 real changes made)
(524 real changes made)
(132 real changes made)
(1,294 real changes made)
(11,827 real changes made)
(1,847 real changes made)
(5,431 real changes made)
(5,676 real changes made)
(3,663 real changes made)
(10,799 real changes made)
(13,790 real changes made)
(18,070 real changes made)
(45,913 real changes made)
(69,651 real changes made)
(3,751 real changes made)
(3,771 real changes made)
(4,232 real changes made)
(13,068 real changes made)
(31,523 real changes made)
(40,830 real changes made)
(7,335 real changes made)
(4,778 real changes made)
(4,326 real changes made)
(15,757 real changes made)
(14,630 real changes made)
(19,465 real changes made)
(49,708 real changes made)
(13,436 real changes made)
(2,352 real changes made)
(10,934 real changes made)
(6,460 real changes made)
(3,195 real changes made)
(1,322 real changes made)
(3,738 real changes made)
(5,463 real changes made)
(5,593 real changes made)
(5,558 real changes made)
(1,476 real changes made)
(336 real changes made)
(925 real changes made)
(1,860 real changes made)
(517 real changes made)
(240 real changes made)
(757 real changes made)
(732 real changes made)
(205 real changes made)
(240 real changes made)
(252 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(12 real changes made)
(0 real changes made)
(156 real changes made)
(61 real changes made)
(0 real changes made)
(120 real changes made)
(264 real changes made)
(0 real changes made)
(96 real changes made)
(36 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(13 real changes made)
(0 real changes made)
(0 real changes made)
(24 real changes made)
(652 real changes made)
(0 real changes made)
(132 real changes made)
(144 real changes made)
(0 real changes made)
(216 real changes made)
(0 real changes made)
(0 real changes made)
(144 real changes made)
(0 real changes made)
(0 real changes made)
(769 real changes made)
(0 real changes made)
(0 real changes made)
(180 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(216 real changes made)
(0 real changes made)
(84 real changes made)
(0 real changes made)
(132 real changes made)
(0 real changes made)
(0 real changes made)
(96 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(12 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(48 real changes made)

{com}. 
. replace ts = 1 if ts == . // fix missings 
{txt}(152 real changes made)

{com}. by ts, sort: gen panel_e=_n // 
{txt}
{com}. tsset panel_e ts // 
{res}
{col 1}{txt:Panel variable: }{res:panel_e}{txt: (unbalanced)}
{p 1 16 2}{txt:Time variable: }{res:ts}{txt:, }{res:{bind:1}}{txt: to }{res:{bind:261}}{txt:, but with gaps}{p_end}
{txt}{col 10}Delta: {res}1 unit
{txt}
{com}. tsfill // 
{txt}
{com}. tab ts // 1-261 w/o gaps. 

         {txt}ts {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          1 {c |}{res}        316        0.01        0.01
{txt}          2 {c |}{res}        316        0.01        0.03
{txt}          3 {c |}{res}        316        0.01        0.04
{txt}          4 {c |}{res}        316        0.01        0.06
{txt}          5 {c |}{res}        316        0.01        0.07
{txt}          6 {c |}{res}        316        0.01        0.09
{txt}          7 {c |}{res}        316        0.01        0.10
{txt}          8 {c |}{res}        316        0.01        0.12
{txt}          9 {c |}{res}        316        0.01        0.13
{txt}         10 {c |}{res}        316        0.01        0.15
{txt}         11 {c |}{res}        316        0.01        0.16
{txt}         12 {c |}{res}        316        0.01        0.18
{txt}         13 {c |}{res}        316        0.01        0.19
{txt}         14 {c |}{res}        316        0.01        0.21
{txt}         15 {c |}{res}        518        0.02        0.23
{txt}         16 {c |}{res}        518        0.02        0.25
{txt}         17 {c |}{res}        518        0.02        0.28
{txt}         18 {c |}{res}        518        0.02        0.30
{txt}         19 {c |}{res}      2,510        0.12        0.42
{txt}         20 {c |}{res}      2,510        0.12        0.53
{txt}         21 {c |}{res}      2,510        0.12        0.65
{txt}         22 {c |}{res}      2,510        0.12        0.77
{txt}         23 {c |}{res}      2,510        0.12        0.88
{txt}         24 {c |}{res}      2,510        0.12        1.00
{txt}         25 {c |}{res}      2,510        0.12        1.12
{txt}         26 {c |}{res}      2,510        0.12        1.23
{txt}         27 {c |}{res}      2,510        0.12        1.35
{txt}         28 {c |}{res}      2,510        0.12        1.46
{txt}         29 {c |}{res}      3,658        0.17        1.63
{txt}         30 {c |}{res}      3,658        0.17        1.80
{txt}         31 {c |}{res}      3,658        0.17        1.97
{txt}         32 {c |}{res}      3,658        0.17        2.14
{txt}         33 {c |}{res}      3,658        0.17        2.31
{txt}         34 {c |}{res}      3,658        0.17        2.48
{txt}         35 {c |}{res}      3,658        0.17        2.65
{txt}         36 {c |}{res}      3,658        0.17        2.82
{txt}         37 {c |}{res}      3,658        0.17        2.99
{txt}         38 {c |}{res}      3,658        0.17        3.16
{txt}         39 {c |}{res}     16,678        0.77        3.93
{txt}         40 {c |}{res}     16,678        0.77        4.71
{txt}         41 {c |}{res}     16,678        0.77        5.48
{txt}         42 {c |}{res}     16,678        0.77        6.25
{txt}         43 {c |}{res}     16,678        0.77        7.02
{txt}         44 {c |}{res}     16,678        0.77        7.80
{txt}         45 {c |}{res}     16,678        0.77        8.57
{txt}         46 {c |}{res}     16,678        0.77        9.34
{txt}         47 {c |}{res}     16,678        0.77       10.12
{txt}         48 {c |}{res}     16,678        0.77       10.89
{txt}         49 {c |}{res}     16,678        0.77       11.66
{txt}         50 {c |}{res}     16,678        0.77       12.44
{txt}         51 {c |}{res}     16,678        0.77       13.21
{txt}         52 {c |}{res}     16,678        0.77       13.98
{txt}         53 {c |}{res}     16,678        0.77       14.75
{txt}         54 {c |}{res}     16,678        0.77       15.53
{txt}         55 {c |}{res}     16,678        0.77       16.30
{txt}         56 {c |}{res}     16,678        0.77       17.07
{txt}         57 {c |}{res}     16,678        0.77       17.85
{txt}         58 {c |}{res}     16,678        0.77       18.62
{txt}         59 {c |}{res}     16,678        0.77       19.39
{txt}         60 {c |}{res}     16,678        0.77       20.17
{txt}         61 {c |}{res}     18,070        0.84       21.00
{txt}         62 {c |}{res}     18,070        0.84       21.84
{txt}         63 {c |}{res}     45,913        2.13       23.97
{txt}         64 {c |}{res}     45,913        2.13       26.10
{txt}         65 {c |}{res}     69,651        3.23       29.32
{txt}         66 {c |}{res}     49,708        2.30       31.63
{txt}         67 {c |}{res}     49,708        2.30       33.93
{txt}         68 {c |}{res}     49,708        2.30       36.24
{txt}         69 {c |}{res}     49,708        2.30       38.54
{txt}         70 {c |}{res}     49,708        2.30       40.84
{txt}         71 {c |}{res}     49,708        2.30       43.15
{txt}         72 {c |}{res}     49,708        2.30       45.45
{txt}         73 {c |}{res}     49,708        2.30       47.76
{txt}         74 {c |}{res}     49,708        2.30       50.06
{txt}         75 {c |}{res}     49,708        2.30       52.36
{txt}         76 {c |}{res}     49,708        2.30       54.67
{txt}         77 {c |}{res}     49,708        2.30       56.97
{txt}         78 {c |}{res}     49,708        2.30       59.27
{txt}         79 {c |}{res}     49,708        2.30       61.58
{txt}         80 {c |}{res}     49,708        2.30       63.88
{txt}         81 {c |}{res}     49,708        2.30       66.19
{txt}         82 {c |}{res}     49,708        2.30       68.49
{txt}         83 {c |}{res}     49,708        2.30       70.79
{txt}         84 {c |}{res}     49,708        2.30       73.10
{txt}         85 {c |}{res}     49,708        2.30       75.40
{txt}         86 {c |}{res}     49,708        2.30       77.71
{txt}         87 {c |}{res}     49,708        2.30       80.01
{txt}         88 {c |}{res}     49,708        2.30       82.31
{txt}         89 {c |}{res}     49,708        2.30       84.62
{txt}         90 {c |}{res}     49,708        2.30       86.92
{txt}         91 {c |}{res}     49,708        2.30       89.22
{txt}         92 {c |}{res}     13,436        0.62       89.85
{txt}         93 {c |}{res}     13,436        0.62       90.47
{txt}         94 {c |}{res}     10,934        0.51       90.98
{txt}         95 {c |}{res}     10,934        0.51       91.48
{txt}         96 {c |}{res}     10,934        0.51       91.99
{txt}         97 {c |}{res}     10,934        0.51       92.50
{txt}         98 {c |}{res}      6,460        0.30       92.80
{txt}         99 {c |}{res}      6,460        0.30       93.10
{txt}        100 {c |}{res}      5,593        0.26       93.36
{txt}        101 {c |}{res}      5,593        0.26       93.61
{txt}        102 {c |}{res}      5,593        0.26       93.87
{txt}        103 {c |}{res}      5,593        0.26       94.13
{txt}        104 {c |}{res}      5,593        0.26       94.39
{txt}        105 {c |}{res}      5,593        0.26       94.65
{txt}        106 {c |}{res}      5,593        0.26       94.91
{txt}        107 {c |}{res}      5,593        0.26       95.17
{txt}        108 {c |}{res}      5,593        0.26       95.43
{txt}        109 {c |}{res}      5,593        0.26       95.69
{txt}        110 {c |}{res}      5,558        0.26       95.95
{txt}        111 {c |}{res}      5,558        0.26       96.20
{txt}        112 {c |}{res}      1,860        0.09       96.29
{txt}        113 {c |}{res}      1,860        0.09       96.38
{txt}        114 {c |}{res}      1,860        0.09       96.46
{txt}        115 {c |}{res}      1,860        0.09       96.55
{txt}        116 {c |}{res}      1,860        0.09       96.63
{txt}        117 {c |}{res}      1,860        0.09       96.72
{txt}        118 {c |}{res}      1,860        0.09       96.81
{txt}        119 {c |}{res}      1,860        0.09       96.89
{txt}        120 {c |}{res}        769        0.04       96.93
{txt}        121 {c |}{res}        769        0.04       96.96
{txt}        122 {c |}{res}        769        0.04       97.00
{txt}        123 {c |}{res}        769        0.04       97.04
{txt}        124 {c |}{res}        769        0.04       97.07
{txt}        125 {c |}{res}        769        0.04       97.11
{txt}        126 {c |}{res}        769        0.04       97.14
{txt}        127 {c |}{res}        769        0.04       97.18
{txt}        128 {c |}{res}        769        0.04       97.21
{txt}        129 {c |}{res}        769        0.04       97.25
{txt}        130 {c |}{res}        769        0.04       97.29
{txt}        131 {c |}{res}        769        0.04       97.32
{txt}        132 {c |}{res}        769        0.04       97.36
{txt}        133 {c |}{res}        769        0.04       97.39
{txt}        134 {c |}{res}        769        0.04       97.43
{txt}        135 {c |}{res}        769        0.04       97.46
{txt}        136 {c |}{res}        769        0.04       97.50
{txt}        137 {c |}{res}        769        0.04       97.53
{txt}        138 {c |}{res}        769        0.04       97.57
{txt}        139 {c |}{res}        769        0.04       97.61
{txt}        140 {c |}{res}        769        0.04       97.64
{txt}        141 {c |}{res}        769        0.04       97.68
{txt}        142 {c |}{res}        769        0.04       97.71
{txt}        143 {c |}{res}        769        0.04       97.75
{txt}        144 {c |}{res}        769        0.04       97.78
{txt}        145 {c |}{res}        769        0.04       97.82
{txt}        146 {c |}{res}        769        0.04       97.86
{txt}        147 {c |}{res}        769        0.04       97.89
{txt}        148 {c |}{res}        769        0.04       97.93
{txt}        149 {c |}{res}        769        0.04       97.96
{txt}        150 {c |}{res}        769        0.04       98.00
{txt}        151 {c |}{res}        769        0.04       98.03
{txt}        152 {c |}{res}        769        0.04       98.07
{txt}        153 {c |}{res}        769        0.04       98.10
{txt}        154 {c |}{res}        769        0.04       98.14
{txt}        155 {c |}{res}        769        0.04       98.18
{txt}        156 {c |}{res}        769        0.04       98.21
{txt}        157 {c |}{res}        769        0.04       98.25
{txt}        158 {c |}{res}        769        0.04       98.28
{txt}        159 {c |}{res}        769        0.04       98.32
{txt}        160 {c |}{res}        769        0.04       98.35
{txt}        161 {c |}{res}        769        0.04       98.39
{txt}        162 {c |}{res}        769        0.04       98.43
{txt}        163 {c |}{res}        769        0.04       98.46
{txt}        164 {c |}{res}        769        0.04       98.50
{txt}        165 {c |}{res}        769        0.04       98.53
{txt}        166 {c |}{res}        769        0.04       98.57
{txt}        167 {c |}{res}        769        0.04       98.60
{txt}        168 {c |}{res}        769        0.04       98.64
{txt}        169 {c |}{res}        769        0.04       98.68
{txt}        170 {c |}{res}        769        0.04       98.71
{txt}        171 {c |}{res}        769        0.04       98.75
{txt}        172 {c |}{res}        769        0.04       98.78
{txt}        173 {c |}{res}        769        0.04       98.82
{txt}        174 {c |}{res}        769        0.04       98.85
{txt}        175 {c |}{res}        769        0.04       98.89
{txt}        176 {c |}{res}        769        0.04       98.92
{txt}        177 {c |}{res}        769        0.04       98.96
{txt}        178 {c |}{res}        769        0.04       99.00
{txt}        179 {c |}{res}        769        0.04       99.03
{txt}        180 {c |}{res}        769        0.04       99.07
{txt}        181 {c |}{res}        769        0.04       99.10
{txt}        182 {c |}{res}        769        0.04       99.14
{txt}        183 {c |}{res}        769        0.04       99.17
{txt}        184 {c |}{res}        769        0.04       99.21
{txt}        185 {c |}{res}        769        0.04       99.25
{txt}        186 {c |}{res}        769        0.04       99.28
{txt}        187 {c |}{res}        769        0.04       99.32
{txt}        188 {c |}{res}        769        0.04       99.35
{txt}        189 {c |}{res}        769        0.04       99.39
{txt}        190 {c |}{res}        769        0.04       99.42
{txt}        191 {c |}{res}        769        0.04       99.46
{txt}        192 {c |}{res}        769        0.04       99.49
{txt}        193 {c |}{res}        769        0.04       99.53
{txt}        194 {c |}{res}        769        0.04       99.57
{txt}        195 {c |}{res}        769        0.04       99.60
{txt}        196 {c |}{res}        769        0.04       99.64
{txt}        197 {c |}{res}        769        0.04       99.67
{txt}        198 {c |}{res}        216        0.01       99.68
{txt}        199 {c |}{res}        216        0.01       99.69
{txt}        200 {c |}{res}        216        0.01       99.70
{txt}        201 {c |}{res}        216        0.01       99.71
{txt}        202 {c |}{res}        216        0.01       99.72
{txt}        203 {c |}{res}        216        0.01       99.73
{txt}        204 {c |}{res}        216        0.01       99.74
{txt}        205 {c |}{res}        216        0.01       99.75
{txt}        206 {c |}{res}        216        0.01       99.76
{txt}        207 {c |}{res}        216        0.01       99.77
{txt}        208 {c |}{res}        216        0.01       99.78
{txt}        209 {c |}{res}        216        0.01       99.79
{txt}        210 {c |}{res}        216        0.01       99.80
{txt}        211 {c |}{res}        216        0.01       99.81
{txt}        212 {c |}{res}        216        0.01       99.82
{txt}        213 {c |}{res}        216        0.01       99.83
{txt}        214 {c |}{res}        216        0.01       99.84
{txt}        215 {c |}{res}        216        0.01       99.85
{txt}        216 {c |}{res}        132        0.01       99.86
{txt}        217 {c |}{res}        132        0.01       99.87
{txt}        218 {c |}{res}        132        0.01       99.87
{txt}        219 {c |}{res}        132        0.01       99.88
{txt}        220 {c |}{res}        132        0.01       99.88
{txt}        221 {c |}{res}        132        0.01       99.89
{txt}        222 {c |}{res}        132        0.01       99.90
{txt}        223 {c |}{res}        132        0.01       99.90
{txt}        224 {c |}{res}         96        0.00       99.91
{txt}        225 {c |}{res}         96        0.00       99.91
{txt}        226 {c |}{res}         96        0.00       99.92
{txt}        227 {c |}{res}         96        0.00       99.92
{txt}        228 {c |}{res}         96        0.00       99.92
{txt}        229 {c |}{res}         96        0.00       99.93
{txt}        230 {c |}{res}         48        0.00       99.93
{txt}        231 {c |}{res}         48        0.00       99.93
{txt}        232 {c |}{res}         48        0.00       99.94
{txt}        233 {c |}{res}         48        0.00       99.94
{txt}        234 {c |}{res}         48        0.00       99.94
{txt}        235 {c |}{res}         48        0.00       99.94
{txt}        236 {c |}{res}         48        0.00       99.94
{txt}        237 {c |}{res}         48        0.00       99.95
{txt}        238 {c |}{res}         48        0.00       99.95
{txt}        239 {c |}{res}         48        0.00       99.95
{txt}        240 {c |}{res}         48        0.00       99.95
{txt}        241 {c |}{res}         48        0.00       99.96
{txt}        242 {c |}{res}         48        0.00       99.96
{txt}        243 {c |}{res}         48        0.00       99.96
{txt}        244 {c |}{res}         48        0.00       99.96
{txt}        245 {c |}{res}         48        0.00       99.96
{txt}        246 {c |}{res}         48        0.00       99.97
{txt}        247 {c |}{res}         48        0.00       99.97
{txt}        248 {c |}{res}         48        0.00       99.97
{txt}        249 {c |}{res}         48        0.00       99.97
{txt}        250 {c |}{res}         48        0.00       99.98
{txt}        251 {c |}{res}         48        0.00       99.98
{txt}        252 {c |}{res}         48        0.00       99.98
{txt}        253 {c |}{res}         48        0.00       99.98
{txt}        254 {c |}{res}         48        0.00       99.98
{txt}        255 {c |}{res}         48        0.00       99.99
{txt}        256 {c |}{res}         48        0.00       99.99
{txt}        257 {c |}{res}         48        0.00       99.99
{txt}        258 {c |}{res}         48        0.00       99.99
{txt}        259 {c |}{res}         48        0.00      100.00
{txt}        260 {c |}{res}         48        0.00      100.00
{txt}        261 {c |}{res}         48        0.00      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}  2,157,609      100.00
{txt}
{com}. 
. by ts, sort: replace panel_e=_n 
{txt}(2,157,341 real changes made)

{com}. replace added_e = 1 if added_e == . 
{txt}(1,657,392 real changes made)

{com}. drop if panel_e > 1 & added_e == 1 
{txt}(1,657,168 observations deleted)

{com}. 
. gen eei_binf = 0 
{txt}
{com}. summ ts, meanonly
{txt}
{com}.         
. forvalues i=`r(min)'(1)`r(max)' {c -(} 
{txt}  2{com}.         replace eei_binf=((`i') + 12) if ts==`i'
{txt}  3{com}. {c )-}
{txt}(316 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(2 real changes made)
(1 real change made)
(64 real changes made)
(1 real change made)
(178 real changes made)
(1 real change made)
(14 real changes made)
(1 real change made)
(518 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(2,510 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(100 real changes made)
(1 real change made)
(366 real changes made)
(1 real change made)
(3,658 real changes made)
(1 real change made)
(158 real changes made)
(1 real change made)
(1,052 real changes made)
(1 real change made)
(27 real changes made)
(1 real change made)
(3,596 real changes made)
(1 real change made)
(16,678 real changes made)
(1 real change made)
(525 real changes made)
(1 real change made)
(133 real changes made)
(1 real change made)
(1,295 real changes made)
(1 real change made)
(11,827 real changes made)
(1 real change made)
(1,848 real changes made)
(1 real change made)
(5,432 real changes made)
(1 real change made)
(5,677 real changes made)
(1 real change made)
(3,664 real changes made)
(1 real change made)
(10,799 real changes made)
(1 real change made)
(13,790 real changes made)
(1 real change made)
(18,070 real changes made)
(1 real change made)
(45,913 real changes made)
(1 real change made)
(69,651 real changes made)
(1 real change made)
(3,752 real changes made)
(1 real change made)
(3,772 real changes made)
(1 real change made)
(4,233 real changes made)
(1 real change made)
(13,069 real changes made)
(1 real change made)
(31,524 real changes made)
(1 real change made)
(40,831 real changes made)
(1 real change made)
(7,336 real changes made)
(1 real change made)
(4,779 real changes made)
(1 real change made)
(4,327 real changes made)
(1 real change made)
(15,758 real changes made)
(1 real change made)
(14,630 real changes made)
(1 real change made)
(19,465 real changes made)
(1 real change made)
(49,708 real changes made)
(1 real change made)
(13,436 real changes made)
(1 real change made)
(2,353 real changes made)
(1 real change made)
(10,934 real changes made)
(1 real change made)
(6,460 real changes made)
(1 real change made)
(3,195 real changes made)
(1 real change made)
(1,322 real changes made)
(1 real change made)
(3,739 real changes made)
(1 real change made)
(5,463 real changes made)
(1 real change made)
(5,593 real changes made)
(1 real change made)
(5,558 real changes made)
(1 real change made)
(1,476 real changes made)
(1 real change made)
(337 real changes made)
(1 real change made)
(925 real changes made)
(1 real change made)
(1,860 real changes made)
(1 real change made)
(517 real changes made)
(1 real change made)
(241 real changes made)
(1 real change made)
(757 real changes made)
(1 real change made)
(732 real changes made)
(1 real change made)
(206 real changes made)
(1 real change made)
(241 real changes made)
(1 real change made)
(253 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(13 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(157 real changes made)
(1 real change made)
(62 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(121 real changes made)
(1 real change made)
(264 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(97 real changes made)
(1 real change made)
(37 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(14 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(25 real changes made)
(1 real change made)
(652 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(133 real changes made)
(1 real change made)
(145 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(217 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(145 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(769 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(180 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(216 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(85 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(132 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(96 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(13 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(48 real changes made)

{com}. 
. replace eei_bin = eei_binf if added_eei == 1  // fill from aux. variable 
{txt}(224 real changes made)

{com}. tab eei_bin 

     {txt}EEI in {c |}
1-unit bins {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
         13 {c |}{res}        164        0.03        0.03
{txt}         14 {c |}{res}          1        0.00        0.03
{txt}         15 {c |}{res}          1        0.00        0.03
{txt}         16 {c |}{res}          2        0.00        0.03
{txt}         17 {c |}{res}         64        0.01        0.05
{txt}         18 {c |}{res}        178        0.04        0.08
{txt}         19 {c |}{res}         14        0.00        0.08
{txt}         20 {c |}{res}        519        0.10        0.19
{txt}         21 {c |}{res}          1        0.00        0.19
{txt}         22 {c |}{res}      2,511        0.50        0.69
{txt}         23 {c |}{res}          1        0.00        0.69
{txt}         24 {c |}{res}          1        0.00        0.69
{txt}         25 {c |}{res}        100        0.02        0.71
{txt}         26 {c |}{res}        366        0.07        0.78
{txt}         27 {c |}{res}      3,658        0.73        1.52
{txt}         28 {c |}{res}        158        0.03        1.55
{txt}         29 {c |}{res}      1,052        0.21        1.76
{txt}         30 {c |}{res}         27        0.01        1.76
{txt}         31 {c |}{res}      3,596        0.72        2.48
{txt}         32 {c |}{res}     16,679        3.33        5.82
{txt}         33 {c |}{res}        525        0.10        5.92
{txt}         34 {c |}{res}        133        0.03        5.95
{txt}         35 {c |}{res}      1,295        0.26        6.21
{txt}         36 {c |}{res}     11,828        2.36        8.57
{txt}         37 {c |}{res}      1,848        0.37        8.94
{txt}         38 {c |}{res}      5,432        1.09       10.03
{txt}         39 {c |}{res}      5,677        1.13       11.16
{txt}         40 {c |}{res}      3,664        0.73       11.89
{txt}         41 {c |}{res}     10,799        2.16       14.05
{txt}         42 {c |}{res}     13,791        2.76       16.81
{txt}         43 {c |}{res}     18,071        3.61       20.42
{txt}         44 {c |}{res}     45,914        9.18       29.60
{txt}         45 {c |}{res}     69,652       13.92       43.52
{txt}         46 {c |}{res}      3,752        0.75       44.27
{txt}         47 {c |}{res}      3,772        0.75       45.02
{txt}         48 {c |}{res}      4,233        0.85       45.87
{txt}         49 {c |}{res}     13,068        2.61       48.48
{txt}         50 {c |}{res}     31,524        6.30       54.78
{txt}         51 {c |}{res}     40,830        8.16       62.94
{txt}         52 {c |}{res}      7,336        1.47       64.41
{txt}         53 {c |}{res}      4,779        0.96       65.37
{txt}         54 {c |}{res}      4,327        0.86       66.23
{txt}         55 {c |}{res}     15,758        3.15       69.38
{txt}         56 {c |}{res}     14,631        2.92       72.30
{txt}         57 {c |}{res}     19,466        3.89       76.20
{txt}         58 {c |}{res}     49,709        9.94       86.13
{txt}         59 {c |}{res}     13,436        2.69       88.82
{txt}         60 {c |}{res}      2,353        0.47       89.29
{txt}         61 {c |}{res}     10,935        2.19       91.47
{txt}         62 {c |}{res}      6,461        1.29       92.76
{txt}         63 {c |}{res}      3,196        0.64       93.40
{txt}         64 {c |}{res}      1,323        0.26       93.67
{txt}         65 {c |}{res}      3,739        0.75       94.42
{txt}         66 {c |}{res}      5,464        1.09       95.51
{txt}         67 {c |}{res}      5,594        1.12       96.63
{txt}         68 {c |}{res}      5,559        1.11       97.74
{txt}         69 {c |}{res}      1,476        0.30       98.03
{txt}         70 {c |}{res}        337        0.07       98.10
{txt}         71 {c |}{res}        925        0.18       98.28
{txt}         72 {c |}{res}      1,861        0.37       98.66
{txt}         73 {c |}{res}        517        0.10       98.76
{txt}         74 {c |}{res}        241        0.05       98.81
{txt}         75 {c |}{res}        757        0.15       98.96
{txt}         76 {c |}{res}        733        0.15       99.11
{txt}         77 {c |}{res}        205        0.04       99.15
{txt}         78 {c |}{res}        241        0.05       99.19
{txt}         79 {c |}{res}        253        0.05       99.25
{txt}         80 {c |}{res}          1        0.00       99.25
{txt}         81 {c |}{res}          1        0.00       99.25
{txt}         82 {c |}{res}          1        0.00       99.25
{txt}         83 {c |}{res}         13        0.00       99.25
{txt}         84 {c |}{res}          1        0.00       99.25
{txt}         85 {c |}{res}        157        0.03       99.28
{txt}         86 {c |}{res}         62        0.01       99.29
{txt}         87 {c |}{res}          1        0.00       99.29
{txt}         88 {c |}{res}        121        0.02       99.32
{txt}         89 {c |}{res}        265        0.05       99.37
{txt}         90 {c |}{res}          1        0.00       99.37
{txt}         91 {c |}{res}         97        0.02       99.39
{txt}         92 {c |}{res}         37        0.01       99.40
{txt}         93 {c |}{res}          1        0.00       99.40
{txt}         94 {c |}{res}          1        0.00       99.40
{txt}         95 {c |}{res}          1        0.00       99.40
{txt}         96 {c |}{res}         14        0.00       99.40
{txt}         97 {c |}{res}          1        0.00       99.40
{txt}         98 {c |}{res}          1        0.00       99.40
{txt}         99 {c |}{res}         24        0.00       99.41
{txt}        100 {c |}{res}        653        0.13       99.54
{txt}        102 {c |}{res}        133        0.03       99.56
{txt}        103 {c |}{res}        144        0.03       99.59
{txt}        104 {c |}{res}          1        0.00       99.59
{txt}        105 {c |}{res}        216        0.04       99.63
{txt}        106 {c |}{res}          1        0.00       99.63
{txt}        107 {c |}{res}          1        0.00       99.64
{txt}        108 {c |}{res}        145        0.03       99.66
{txt}        110 {c |}{res}          1        0.00       99.66
{txt}        111 {c |}{res}        769        0.15       99.82
{txt}        112 {c |}{res}          1        0.00       99.82
{txt}        114 {c |}{res}        181        0.04       99.85
{txt}        116 {c |}{res}          1        0.00       99.85
{txt}        117 {c |}{res}          1        0.00       99.85
{txt}        118 {c |}{res}          1        0.00       99.85
{txt}        120 {c |}{res}        217        0.04       99.90
{txt}        122 {c |}{res}         85        0.02       99.92
{txt}        124 {c |}{res}        133        0.03       99.94
{txt}        126 {c |}{res}          1        0.00       99.94
{txt}        127 {c |}{res}         97        0.02       99.96
{txt}        128 {c |}{res}          1        0.00       99.96
{txt}        130 {c |}{res}          1        0.00       99.96
{txt}        132 {c |}{res}         13        0.00       99.96
{txt}        134 {c |}{res}          1        0.00       99.96
{txt}        135 {c |}{res}          1        0.00       99.96
{txt}        136 {c |}{res}          1        0.00       99.97
{txt}        138 {c |}{res}          1        0.00       99.97
{txt}        140 {c |}{res}          1        0.00       99.97
{txt}        141 {c |}{res}          1        0.00       99.97
{txt}        142 {c |}{res}          1        0.00       99.97
{txt}        143 {c |}{res}         49        0.01       99.98
{txt}        144 {c |}{res}          1        0.00       99.98
{txt}        145 {c |}{res}          1        0.00       99.98
{txt}        146 {c |}{res}          1        0.00       99.98
{txt}        147 {c |}{res}          1        0.00       99.98
{txt}        148 {c |}{res}          1        0.00       99.98
{txt}        149 {c |}{res}          1        0.00       99.98
{txt}        150 {c |}{res}          1        0.00       99.98
{txt}        151 {c |}{res}          1        0.00       99.98
{txt}        152 {c |}{res}          1        0.00       99.98
{txt}        153 {c |}{res}          1        0.00       99.98
{txt}        154 {c |}{res}          1        0.00       99.98
{txt}        155 {c |}{res}          1        0.00       99.98
{txt}        156 {c |}{res}          1        0.00       99.98
{txt}        157 {c |}{res}          1        0.00       99.98
{txt}        158 {c |}{res}          1        0.00       99.98
{txt}        159 {c |}{res}          1        0.00       99.98
{txt}        160 {c |}{res}          1        0.00       99.98
{txt}        161 {c |}{res}          1        0.00       99.98
{txt}        162 {c |}{res}          1        0.00       99.98
{txt}        163 {c |}{res}          1        0.00       99.98
{txt}        164 {c |}{res}          1        0.00       99.98
{txt}        166 {c |}{res}          1        0.00       99.98
{txt}        167 {c |}{res}          1        0.00       99.98
{txt}        168 {c |}{res}          1        0.00       99.98
{txt}        169 {c |}{res}          1        0.00       99.98
{txt}        170 {c |}{res}          1        0.00       99.98
{txt}        171 {c |}{res}          1        0.00       99.98
{txt}        172 {c |}{res}          1        0.00       99.98
{txt}        173 {c |}{res}          1        0.00       99.98
{txt}        174 {c |}{res}          1        0.00       99.98
{txt}        175 {c |}{res}          1        0.00       99.98
{txt}        176 {c |}{res}          1        0.00       99.98
{txt}        177 {c |}{res}          1        0.00       99.98
{txt}        178 {c |}{res}          1        0.00       99.98
{txt}        179 {c |}{res}          1        0.00       99.98
{txt}        180 {c |}{res}          1        0.00       99.98
{txt}        181 {c |}{res}          1        0.00       99.98
{txt}        182 {c |}{res}          1        0.00       99.98
{txt}        183 {c |}{res}          1        0.00       99.98
{txt}        184 {c |}{res}          1        0.00       99.98
{txt}        185 {c |}{res}          1        0.00       99.98
{txt}        186 {c |}{res}          1        0.00       99.98
{txt}        188 {c |}{res}          1        0.00       99.98
{txt}        189 {c |}{res}          1        0.00       99.98
{txt}        190 {c |}{res}          1        0.00       99.98
{txt}        191 {c |}{res}          1        0.00       99.98
{txt}        192 {c |}{res}          1        0.00       99.99
{txt}        193 {c |}{res}          1        0.00       99.99
{txt}        194 {c |}{res}          1        0.00       99.99
{txt}        195 {c |}{res}          1        0.00       99.99
{txt}        196 {c |}{res}          1        0.00       99.99
{txt}        197 {c |}{res}          1        0.00       99.99
{txt}        198 {c |}{res}          1        0.00       99.99
{txt}        199 {c |}{res}          1        0.00       99.99
{txt}        200 {c |}{res}          1        0.00       99.99
{txt}        201 {c |}{res}          1        0.00       99.99
{txt}        202 {c |}{res}          1        0.00       99.99
{txt}        203 {c |}{res}          1        0.00       99.99
{txt}        204 {c |}{res}          1        0.00       99.99
{txt}        205 {c |}{res}          1        0.00       99.99
{txt}        206 {c |}{res}          1        0.00       99.99
{txt}        207 {c |}{res}          1        0.00       99.99
{txt}        208 {c |}{res}          1        0.00       99.99
{txt}        210 {c |}{res}          1        0.00       99.99
{txt}        211 {c |}{res}          1        0.00       99.99
{txt}        212 {c |}{res}          1        0.00       99.99
{txt}        213 {c |}{res}          1        0.00       99.99
{txt}        214 {c |}{res}          1        0.00       99.99
{txt}        216 {c |}{res}          1        0.00       99.99
{txt}        217 {c |}{res}          1        0.00       99.99
{txt}        218 {c |}{res}          1        0.00       99.99
{txt}        219 {c |}{res}          1        0.00       99.99
{txt}        220 {c |}{res}          1        0.00       99.99
{txt}        221 {c |}{res}          1        0.00       99.99
{txt}        222 {c |}{res}          1        0.00       99.99
{txt}        223 {c |}{res}          1        0.00       99.99
{txt}        224 {c |}{res}          1        0.00       99.99
{txt}        225 {c |}{res}          1        0.00       99.99
{txt}        226 {c |}{res}          1        0.00       99.99
{txt}        228 {c |}{res}          1        0.00       99.99
{txt}        229 {c |}{res}          1        0.00       99.99
{txt}        230 {c |}{res}          1        0.00       99.99
{txt}        231 {c |}{res}          1        0.00       99.99
{txt}        232 {c |}{res}          1        0.00       99.99
{txt}        233 {c |}{res}          1        0.00       99.99
{txt}        234 {c |}{res}          1        0.00       99.99
{txt}        236 {c |}{res}          1        0.00       99.99
{txt}        237 {c |}{res}          1        0.00       99.99
{txt}        238 {c |}{res}          1        0.00       99.99
{txt}        239 {c |}{res}          1        0.00       99.99
{txt}        240 {c |}{res}          1        0.00       99.99
{txt}        242 {c |}{res}          1        0.00       99.99
{txt}        243 {c |}{res}          1        0.00       99.99
{txt}        244 {c |}{res}          1        0.00       99.99
{txt}        245 {c |}{res}          1        0.00       99.99
{txt}        246 {c |}{res}          1        0.00       99.99
{txt}        247 {c |}{res}          1        0.00      100.00
{txt}        248 {c |}{res}          1        0.00      100.00
{txt}        249 {c |}{res}          1        0.00      100.00
{txt}        250 {c |}{res}          1        0.00      100.00
{txt}        251 {c |}{res}          1        0.00      100.00
{txt}        252 {c |}{res}          1        0.00      100.00
{txt}        253 {c |}{res}          1        0.00      100.00
{txt}        254 {c |}{res}          1        0.00      100.00
{txt}        255 {c |}{res}          1        0.00      100.00
{txt}        256 {c |}{res}          1        0.00      100.00
{txt}        257 {c |}{res}          1        0.00      100.00
{txt}        258 {c |}{res}          1        0.00      100.00
{txt}        259 {c |}{res}          1        0.00      100.00
{txt}        260 {c |}{res}          1        0.00      100.00
{txt}        261 {c |}{res}          1        0.00      100.00
{txt}        262 {c |}{res}          1        0.00      100.00
{txt}        263 {c |}{res}          1        0.00      100.00
{txt}        264 {c |}{res}          1        0.00      100.00
{txt}        265 {c |}{res}          1        0.00      100.00
{txt}        266 {c |}{res}          1        0.00      100.00
{txt}        267 {c |}{res}          1        0.00      100.00
{txt}        268 {c |}{res}          1        0.00      100.00
{txt}        269 {c |}{res}          1        0.00      100.00
{txt}        270 {c |}{res}          1        0.00      100.00
{txt}        271 {c |}{res}          1        0.00      100.00
{txt}        272 {c |}{res}          1        0.00      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    500,289      100.00
{txt}
{com}. 
. drop ts eei_binf
{txt}
{com}. 
. ***********************************************
. *** complete grid by filling in combinations ****
.  
. sort a_bin s_bin
{txt}
{com}. 
. fillin a_bin s_bin      // expand grid to all combinations. 
{txt}
{com}. 
. ** adjust: fillin sets year to missing, would get dropped in collapse  
. replace year = 2017 if year == . & _fillin == 1 // replace if created by _fillin 
{txt}(4,693 real changes made)

{com}. tab year, missing // 79 obs still missing year. 

       {txt}year {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
       2004 {c |}{res}        473        0.09        0.09
{txt}       2005 {c |}{res}      1,000        0.20        0.29
{txt}       2006 {c |}{res}      2,276        0.45        0.74
{txt}       2007 {c |}{res}      4,049        0.80        1.54
{txt}       2008 {c |}{res}      6,257        1.24        2.78
{txt}       2009 {c |}{res}     12,340        2.44        5.23
{txt}       2010 {c |}{res}     21,071        4.17        9.40
{txt}       2011 {c |}{res}     37,766        7.48       16.87
{txt}       2012 {c |}{res}     60,390       11.96       28.83
{txt}       2013 {c |}{res}     78,090       15.46       44.29
{txt}       2014 {c |}{res}     86,773       17.18       61.47
{txt}       2015 {c |}{res}     88,466       17.51       78.98
{txt}       2016 {c |}{res}     89,176       17.65       96.63
{txt}       2017 {c |}{res}     16,631        3.29       99.93
{txt}          . {c |}{res}        376        0.07      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    505,134      100.00
{txt}
{com}. list id units a_bin s_bin if year == . // all have missing id. no concern. 
{txt}
        {c TLC}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c TRC}
        {c |} {res}id   units   a_bin   s_bin {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
242640. {c |} {res}         .     6.5       . {txt}{c |}
391167. {c |} {res}         .     7.5       . {txt}{c |}
474871. {c |} {res}         .     8.5       . {txt}{c |}
493234. {c |} {res}         .     9.5       . {txt}{c |}
498894. {c |} {res}         .    10.5       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
501375. {c |} {res}         .    11.5       . {txt}{c |}
503431. {c |} {res}         .    12.5       . {txt}{c |}
503954. {c |} {res}         .    13.5       . {txt}{c |}
504165. {c |} {res}         .      14       . {txt}{c |}
504365. {c |} {res}         .    14.5       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504713. {c |} {res}         .       .    -252 {txt}{c |}
504714. {c |} {res}         .       .    -249 {txt}{c |}
504715. {c |} {res}         .       .    -246 {txt}{c |}
504716. {c |} {res}         .       .    -243 {txt}{c |}
504717. {c |} {res}         .       .    -240 {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504718. {c |} {res}         .       .    -237 {txt}{c |}
504719. {c |} {res}         .       .    -234 {txt}{c |}
504720. {c |} {res}         .       .    -231 {txt}{c |}
504721. {c |} {res}         .       .    -228 {txt}{c |}
504723. {c |} {res}         .       .    -222 {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504724. {c |} {res}         .       .    -219 {txt}{c |}
504726. {c |} {res}         .       .    -213 {txt}{c |}
504727. {c |} {res}         .       .    -210 {txt}{c |}
504728. {c |} {res}         .       .    -207 {txt}{c |}
504729. {c |} {res}         .       .    -204 {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504730. {c |} {res}         .       .    -201 {txt}{c |}
504731. {c |} {res}         .       .    -198 {txt}{c |}
504733. {c |} {res}         .       .    -192 {txt}{c |}
504735. {c |} {res}         .       .    -186 {txt}{c |}
504736. {c |} {res}         .       .    -183 {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504739. {c |} {res}         .       .    -174 {txt}{c |}
504740. {c |} {res}         .       .    -171 {txt}{c |}
504741. {c |} {res}         .       .    -168 {txt}{c |}
504742. {c |} {res}         .       .    -165 {txt}{c |}
504743. {c |} {res}         .       .    -162 {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504744. {c |} {res}         .       .    -159 {txt}{c |}
504745. {c |} {res}         .       .    -156 {txt}{c |}
504747. {c |} {res}         .       .    -150 {txt}{c |}
504748. {c |} {res}         .       .    -147 {txt}{c |}
504749. {c |} {res}         .       .    -144 {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504752. {c |} {res}         .       .    -135 {txt}{c |}
504753. {c |} {res}         .       .    -132 {txt}{c |}
504755. {c |} {res}         .       .    -126 {txt}{c |}
504756. {c |} {res}         .       .    -123 {txt}{c |}
504757. {c |} {res}         .       .    -120 {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504759. {c |} {res}         .       .    -114 {txt}{c |}
504760. {c |} {res}         .       .    -111 {txt}{c |}
504761. {c |} {res}         .       .    -108 {txt}{c |}
504763. {c |} {res}         .       .    -102 {txt}{c |}
504764. {c |} {res}         .       .     -99 {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504765. {c |} {res}         .       .     -96 {txt}{c |}
504767. {c |} {res}         .       .     -90 {txt}{c |}
504769. {c |} {res}         .       .     -84 {txt}{c |}
504770. {c |} {res}         .       .     -81 {txt}{c |}
504772. {c |} {res}         .       .     -75 {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504774. {c |} {res}         .       .     -69 {txt}{c |}
504784. {c |} {res}         .       .     -39 {txt}{c |}
504785. {c |} {res}         .       .     -36 {txt}{c |}
504790. {c |} {res}         .       .     -21 {txt}{c |}
504791. {c |} {res}         .       .     -18 {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504798. {c |} {res}         .       .       3 {txt}{c |}
504800. {c |} {res}         .       .       9 {txt}{c |}
504802. {c |} {res}         .       .      15 {txt}{c |}
504804. {c |} {res}         .       .      21 {txt}{c |}
504805. {c |} {res}         .       .      24 {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504808. {c |} {res}         .       .      33 {txt}{c |}
504809. {c |} {res}         .       .      36 {txt}{c |}
504814. {c |} {res}         .       .      51 {txt}{c |}
504815. {c |} {res}         .       .      54 {txt}{c |}
504816. {c |} {res}         .       .      57 {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504817. {c |} {res}         .       .      60 {txt}{c |}
504818. {c |} {res}         .       .      63 {txt}{c |}
504820. {c |} {res}         .       .      69 {txt}{c |}
504821. {c |} {res}         .       .      72 {txt}{c |}
504822. {c |} {res}         .       .      75 {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504823. {c |} {res}         .       .      78 {txt}{c |}
504824. {c |} {res}         .       .      81 {txt}{c |}
504825. {c |} {res}         .       .      84 {txt}{c |}
504826. {c |} {res}         .       .      87 {txt}{c |}
504827. {c |} {res}         .       .      90 {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504828. {c |} {res}         .       .      93 {txt}{c |}
504829. {c |} {res}         .       .      96 {txt}{c |}
504830. {c |} {res}         .       .      99 {txt}{c |}
504831. {c |} {res}         .       .     102 {txt}{c |}
504832. {c |} {res}         .       .     105 {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504833. {c |} {res}         .       .     108 {txt}{c |}
504834. {c |} {res}         .       .     111 {txt}{c |}
504836. {c |} {res}         .       .     117 {txt}{c |}
504838. {c |} {res}         .       .     123 {txt}{c |}
504840. {c |} {res}         .       .     129 {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504841. {c |} {res}         .       .     132 {txt}{c |}
504842. {c |} {res}         .       .     135 {txt}{c |}
504844. {c |} {res}         .       .     141 {txt}{c |}
504845. {c |} {res}         .       .     144 {txt}{c |}
504846. {c |} {res}         .       .     147 {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504847. {c |} {res}         .       .     150 {txt}{c |}
504848. {c |} {res}         .       .     153 {txt}{c |}
504849. {c |} {res}         .       .     156 {txt}{c |}
504850. {c |} {res}         .       .     159 {txt}{c |}
504851. {c |} {res}         .       .     162 {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504852. {c |} {res}         .       .     165 {txt}{c |}
504853. {c |} {res}         .       .     168 {txt}{c |}
504854. {c |} {res}         .       .     171 {txt}{c |}
504856. {c |} {res}         .       .     177 {txt}{c |}
504859. {c |} {res}         .       .     186 {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504860. {c |} {res}         .       .     189 {txt}{c |}
504861. {c |} {res}         .       .     192 {txt}{c |}
504862. {c |} {res}         .       .     195 {txt}{c |}
504863. {c |} {res}         .       .     198 {txt}{c |}
504864. {c |} {res}         .       .     201 {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504865. {c |} {res}         .       .     204 {txt}{c |}
504867. {c |} {res}         .       .     210 {txt}{c |}
504868. {c |} {res}         .       .     213 {txt}{c |}
504869. {c |} {res}         .       .     216 {txt}{c |}
504871. {c |} {res}         .       .     222 {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504872. {c |} {res}         .       .     225 {txt}{c |}
504873. {c |} {res}         .       .     228 {txt}{c |}
504874. {c |} {res}         .       .     231 {txt}{c |}
504875. {c |} {res}         .       .     234 {txt}{c |}
504876. {c |} {res}         .       .     237 {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504877. {c |} {res}         .       .     240 {txt}{c |}
504878. {c |} {res}         .       .     243 {txt}{c |}
504879. {c |} {res}         .       .     246 {txt}{c |}
504880. {c |} {res}         .       .     249 {txt}{c |}
504881. {c |} {res}         .       .     252 {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504882. {c |} {res}         .       .     255 {txt}{c |}
504884. {c |} {res}         .       .     261 {txt}{c |}
504885. {c |} {res}         .       .     264 {txt}{c |}
504886. {c |} {res}         .       .     267 {txt}{c |}
504887. {c |} {res}         .       .     270 {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504888. {c |} {res}         .       .     273 {txt}{c |}
504889. {c |} {res}         .       .     276 {txt}{c |}
504890. {c |} {res}         .       .     279 {txt}{c |}
504891. {c |} {res}         .       .     282 {txt}{c |}
504892. {c |} {res}         .       .     285 {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504893. {c |} {res}         .       .     288 {txt}{c |}
504894. {c |} {res}         .       .     291 {txt}{c |}
504895. {c |} {res}         .       .     294 {txt}{c |}
504896. {c |} {res}         .       .     297 {txt}{c |}
504897. {c |} {res}         .       .     300 {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504898. {c |} {res}         .       .     303 {txt}{c |}
504899. {c |} {res}         .       .     306 {txt}{c |}
504900. {c |} {res}         .       .     309 {txt}{c |}
504901. {c |} {res}         .       .     312 {txt}{c |}
504902. {c |} {res}         .       .     315 {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504903. {c |} {res}         .       .     318 {txt}{c |}
504904. {c |} {res}         .       .     321 {txt}{c |}
504905. {c |} {res}         .       .     324 {txt}{c |}
504906. {c |} {res}         .       .     327 {txt}{c |}
504907. {c |} {res}         .       .     330 {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504908. {c |} {res}         .       .     333 {txt}{c |}
504909. {c |} {res}         .       .     336 {txt}{c |}
504911. {c |} {res}         .       .       . {txt}{c |}
504912. {c |} {res}         .       .       . {txt}{c |}
504913. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504914. {c |} {res}         .       .       . {txt}{c |}
504915. {c |} {res}         .       .       . {txt}{c |}
504916. {c |} {res}         .       .       . {txt}{c |}
504917. {c |} {res}         .       .       . {txt}{c |}
504918. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504919. {c |} {res}         .       .       . {txt}{c |}
504920. {c |} {res}         .       .       . {txt}{c |}
504921. {c |} {res}         .       .       . {txt}{c |}
504922. {c |} {res}         .       .       . {txt}{c |}
504923. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504924. {c |} {res}         .       .       . {txt}{c |}
504925. {c |} {res}         .       .       . {txt}{c |}
504926. {c |} {res}         .       .       . {txt}{c |}
504927. {c |} {res}         .       .       . {txt}{c |}
504928. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504929. {c |} {res}         .       .       . {txt}{c |}
504930. {c |} {res}         .       .       . {txt}{c |}
504931. {c |} {res}         .       .       . {txt}{c |}
504932. {c |} {res}         .       .       . {txt}{c |}
504933. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504934. {c |} {res}         .       .       . {txt}{c |}
504935. {c |} {res}         .       .       . {txt}{c |}
504936. {c |} {res}         .       .       . {txt}{c |}
504937. {c |} {res}         .       .       . {txt}{c |}
504938. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504939. {c |} {res}         .       .       . {txt}{c |}
504940. {c |} {res}         .       .       . {txt}{c |}
504941. {c |} {res}         .       .       . {txt}{c |}
504942. {c |} {res}         .       .       . {txt}{c |}
504943. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504944. {c |} {res}         .       .       . {txt}{c |}
504945. {c |} {res}         .       .       . {txt}{c |}
504946. {c |} {res}         .       .       . {txt}{c |}
504947. {c |} {res}         .       .       . {txt}{c |}
504948. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504949. {c |} {res}         .       .       . {txt}{c |}
504950. {c |} {res}         .       .       . {txt}{c |}
504951. {c |} {res}         .       .       . {txt}{c |}
504952. {c |} {res}         .       .       . {txt}{c |}
504953. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504954. {c |} {res}         .       .       . {txt}{c |}
504955. {c |} {res}         .       .       . {txt}{c |}
504956. {c |} {res}         .       .       . {txt}{c |}
504957. {c |} {res}         .       .       . {txt}{c |}
504958. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504959. {c |} {res}         .       .       . {txt}{c |}
504960. {c |} {res}         .       .       . {txt}{c |}
504961. {c |} {res}         .       .       . {txt}{c |}
504962. {c |} {res}         .       .       . {txt}{c |}
504963. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504964. {c |} {res}         .       .       . {txt}{c |}
504965. {c |} {res}         .       .       . {txt}{c |}
504966. {c |} {res}         .       .       . {txt}{c |}
504967. {c |} {res}         .       .       . {txt}{c |}
504968. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504969. {c |} {res}         .       .       . {txt}{c |}
504970. {c |} {res}         .       .       . {txt}{c |}
504971. {c |} {res}         .       .       . {txt}{c |}
504972. {c |} {res}         .       .       . {txt}{c |}
504973. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504974. {c |} {res}         .       .       . {txt}{c |}
504975. {c |} {res}         .       .       . {txt}{c |}
504976. {c |} {res}         .       .       . {txt}{c |}
504977. {c |} {res}         .       .       . {txt}{c |}
504978. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504979. {c |} {res}         .       .       . {txt}{c |}
504980. {c |} {res}         .       .       . {txt}{c |}
504981. {c |} {res}         .       .       . {txt}{c |}
504982. {c |} {res}         .       .       . {txt}{c |}
504983. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504984. {c |} {res}         .       .       . {txt}{c |}
504985. {c |} {res}         .       .       . {txt}{c |}
504986. {c |} {res}         .       .       . {txt}{c |}
504987. {c |} {res}         .       .       . {txt}{c |}
504988. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504989. {c |} {res}         .       .       . {txt}{c |}
504990. {c |} {res}         .       .       . {txt}{c |}
504991. {c |} {res}         .       .       . {txt}{c |}
504992. {c |} {res}         .       .       . {txt}{c |}
504993. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504994. {c |} {res}         .       .       . {txt}{c |}
504995. {c |} {res}         .       .       . {txt}{c |}
504996. {c |} {res}         .       .       . {txt}{c |}
504997. {c |} {res}         .       .       . {txt}{c |}
504998. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
504999. {c |} {res}         .       .       . {txt}{c |}
505000. {c |} {res}         .       .       . {txt}{c |}
505001. {c |} {res}         .       .       . {txt}{c |}
505002. {c |} {res}         .       .       . {txt}{c |}
505003. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
505004. {c |} {res}         .       .       . {txt}{c |}
505005. {c |} {res}         .       .       . {txt}{c |}
505006. {c |} {res}         .       .       . {txt}{c |}
505007. {c |} {res}         .       .       . {txt}{c |}
505008. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
505009. {c |} {res}         .       .       . {txt}{c |}
505010. {c |} {res}         .       .       . {txt}{c |}
505011. {c |} {res}         .       .       . {txt}{c |}
505012. {c |} {res}         .       .       . {txt}{c |}
505013. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
505014. {c |} {res}         .       .       . {txt}{c |}
505015. {c |} {res}         .       .       . {txt}{c |}
505016. {c |} {res}         .       .       . {txt}{c |}
505017. {c |} {res}         .       .       . {txt}{c |}
505018. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
505019. {c |} {res}         .       .       . {txt}{c |}
505020. {c |} {res}         .       .       . {txt}{c |}
505021. {c |} {res}         .       .       . {txt}{c |}
505022. {c |} {res}         .       .       . {txt}{c |}
505023. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
505024. {c |} {res}         .       .       . {txt}{c |}
505025. {c |} {res}         .       .       . {txt}{c |}
505026. {c |} {res}         .       .       . {txt}{c |}
505027. {c |} {res}         .       .       . {txt}{c |}
505028. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
505029. {c |} {res}         .       .       . {txt}{c |}
505030. {c |} {res}         .       .       . {txt}{c |}
505031. {c |} {res}         .       .       . {txt}{c |}
505032. {c |} {res}         .       .       . {txt}{c |}
505033. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
505034. {c |} {res}         .       .       . {txt}{c |}
505035. {c |} {res}         .       .       . {txt}{c |}
505036. {c |} {res}         .       .       . {txt}{c |}
505037. {c |} {res}         .       .       . {txt}{c |}
505038. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
505039. {c |} {res}         .       .       . {txt}{c |}
505040. {c |} {res}         .       .       . {txt}{c |}
505041. {c |} {res}         .       .       . {txt}{c |}
505042. {c |} {res}         .       .       . {txt}{c |}
505043. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
505044. {c |} {res}         .       .       . {txt}{c |}
505045. {c |} {res}         .       .       . {txt}{c |}
505046. {c |} {res}         .       .       . {txt}{c |}
505047. {c |} {res}         .       .       . {txt}{c |}
505048. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
505049. {c |} {res}         .       .       . {txt}{c |}
505050. {c |} {res}         .       .       . {txt}{c |}
505051. {c |} {res}         .       .       . {txt}{c |}
505052. {c |} {res}         .       .       . {txt}{c |}
505053. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
505054. {c |} {res}         .       .       . {txt}{c |}
505055. {c |} {res}         .       .       . {txt}{c |}
505056. {c |} {res}         .       .       . {txt}{c |}
505057. {c |} {res}         .       .       . {txt}{c |}
505058. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
505059. {c |} {res}         .       .       . {txt}{c |}
505060. {c |} {res}         .       .       . {txt}{c |}
505061. {c |} {res}         .       .       . {txt}{c |}
505062. {c |} {res}         .       .       . {txt}{c |}
505063. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
505064. {c |} {res}         .       .       . {txt}{c |}
505065. {c |} {res}         .       .       . {txt}{c |}
505066. {c |} {res}         .       .       . {txt}{c |}
505067. {c |} {res}         .       .       . {txt}{c |}
505068. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
505069. {c |} {res}         .       .       . {txt}{c |}
505070. {c |} {res}         .       .       . {txt}{c |}
505071. {c |} {res}         .       .       . {txt}{c |}
505072. {c |} {res}         .       .       . {txt}{c |}
505073. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
505074. {c |} {res}         .       .       . {txt}{c |}
505075. {c |} {res}         .       .       . {txt}{c |}
505076. {c |} {res}         .       .       . {txt}{c |}
505077. {c |} {res}         .       .       . {txt}{c |}
505078. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
505079. {c |} {res}         .       .       . {txt}{c |}
505080. {c |} {res}         .       .       . {txt}{c |}
505081. {c |} {res}         .       .       . {txt}{c |}
505082. {c |} {res}         .       .       . {txt}{c |}
505083. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
505084. {c |} {res}         .       .       . {txt}{c |}
505085. {c |} {res}         .       .       . {txt}{c |}
505086. {c |} {res}         .       .       . {txt}{c |}
505087. {c |} {res}         .       .       . {txt}{c |}
505088. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
505089. {c |} {res}         .       .       . {txt}{c |}
505090. {c |} {res}         .       .       . {txt}{c |}
505091. {c |} {res}         .       .       . {txt}{c |}
505092. {c |} {res}         .       .       . {txt}{c |}
505093. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
505094. {c |} {res}         .       .       . {txt}{c |}
505095. {c |} {res}         .       .       . {txt}{c |}
505096. {c |} {res}         .       .       . {txt}{c |}
505097. {c |} {res}         .       .       . {txt}{c |}
505098. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
505099. {c |} {res}         .       .       . {txt}{c |}
505100. {c |} {res}         .       .       . {txt}{c |}
505101. {c |} {res}         .       .       . {txt}{c |}
505102. {c |} {res}         .       .       . {txt}{c |}
505103. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
505104. {c |} {res}         .       .       . {txt}{c |}
505105. {c |} {res}         .       .       . {txt}{c |}
505106. {c |} {res}         .       .       . {txt}{c |}
505107. {c |} {res}         .       .       . {txt}{c |}
505108. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
505109. {c |} {res}         .       .       . {txt}{c |}
505110. {c |} {res}         .       .       . {txt}{c |}
505111. {c |} {res}         .       .       . {txt}{c |}
505112. {c |} {res}         .       .       . {txt}{c |}
505113. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
505114. {c |} {res}         .       .       . {txt}{c |}
505115. {c |} {res}         .       .       . {txt}{c |}
505116. {c |} {res}         .       .       . {txt}{c |}
505117. {c |} {res}         .       .       . {txt}{c |}
505118. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
505119. {c |} {res}         .       .       . {txt}{c |}
505120. {c |} {res}         .       .       . {txt}{c |}
505121. {c |} {res}         .       .       . {txt}{c |}
505122. {c |} {res}         .       .       . {txt}{c |}
505123. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
505124. {c |} {res}         .       .       . {txt}{c |}
505125. {c |} {res}         .       .       . {txt}{c |}
505126. {c |} {res}         .       .       . {txt}{c |}
505127. {c |} {res}         .       .       . {txt}{c |}
505128. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
505129. {c |} {res}         .       .       . {txt}{c |}
505130. {c |} {res}         .       .       . {txt}{c |}
505131. {c |} {res}         .       .       . {txt}{c |}
505132. {c |} {res}         .       .       . {txt}{c |}
505133. {c |} {res}         .       .       . {txt}{c |}
        {c LT}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c RT}
505134. {c |} {res}         .       .       . {txt}{c |}
        {c BLC}{hline 4}{c -}{hline 7}{c -}{hline 7}{c -}{hline 7}{c BRC}

{com}. replace year = 2017 if year == . // fix rest. 
{txt}(376 real changes made)

{com}. 
. 
. **** BREAK 1 ******
. save spatial_1_raw_s, replace 
{txt}{p 0 4 2}
file {bf}
spatial_1_raw_s.dta{rm}
saved
{p_end}

{com}. *******************
. 
. log close 
      {txt}name:  {res}<unnamed>
       {txt}log:  {res}R:\WSV2\TBu_AKe\Spatial_NEW\spatial_1_raw_s.smcl
  {txt}log type:  {res}smcl
 {txt}closed on:  {res}27 Mar 2023, 17:37:30
{txt}{.-}
{smcl}
{txt}{sf}{ul off}